[mso] Re: Excel - Master document with sub documents that contain part of the data
- From: Vergel Villacorta <atrocallivlegrev@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 3 Dec 2006 19:16:08 -0800 (PST)
ms.Jenny,
you can used the lookup formulas if you can established an index in the main
worksheet and at the subsheet. maybe you can used the account number.
its very much important to established one so when ther are changes you post
in the main worksheet it can be automatically reflected in your subsheet.
vergel
Jenny Johnson <jj1@xxxxxxxxxxxx> wrote:
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
*************************************************************
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.
*************************************************************
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:
