[mso] MORE INFO - Excel - Master document with sub documents that contain part of the data
- From: "Jenny Johnson" <jj1@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 3 Dec 2006 10:02:35 -0500
I found a formula that would work for finding the first row in a particular
account. It is
=IF(COUNTIF(TOTAL!$A$4:TOTAL!$M$172,
$B$1),VLOOKUP($B$1,TOTAL!$A$4:TOTAL!$M$172, 1, FALSE),"")for the 1st cell
=IF(COUNTIF(TOTAL!$A$4:TOTAL!$M$172,
$B$1),VLOOKUP($B$1,TOTAL!$A$4:TOTAL!$M$172, 2, FALSE),"")for the 2nd cell,
etc.
Is there a way to make this keep searching the TOTAL sheet and then putting
the next row with that account in the subsheet?
This may be more complicated than I can handle..
Jenny
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Jenny Johnson
Sent: Sunday, December 03, 2006 9:24 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel - Master document with sub documents that contain
part of the data
I have an Excel file with stock information - price bought - sold, etc. One
column has the individual account such as IRA, 401K, etc.
I would like to manipulate the data in the total worksheet, but then have
the data for each individual account flow to a subsheet - one for each
account.
I tried sorting the main worksheet by account and then in the subsheet
putting an = to the cells for one account. (I did one row and then pulled
it down and it worked fine - UNTIL I sorted the main sheet and had totally
different data in the subsheet.)
Do you think I need to do some kind of lookup formula? I don't want to have
blank rows in the subsheet.
If you have already discussed this I apologize. I didn't need it until
recently and may have missed it.
Thank you for any help you can offer.
Jenny
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
