[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).
http://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: