(Msg. 1) Posted: Wed Sep 09, 2009 11:18 am
Post subject: Multiple Worksheets, multiple lines and summarizing into one works Archived from groups: microsoft>public>excel>newusers (more info?)
I am working with a spreadsheet which can have multiple spreadsheets all
formatted the same way. Now although these sheets are all formatted the same
way some may have 1 row of data while another may have 10 rows of data. I am
wanting to incorporate these into a summary worksheet at the beginning of my
spreadsheet which will list all of these rows automatically. What kind of
table or formula would I need to look into to make this happen?
(Msg. 2) Posted: Thu Sep 10, 2009 5:05 am
Post subject: Re: Multiple Worksheets, multiple lines and summarizing into one works [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
there is a possible solution at 'Merge cells from all or some
worksheets into one Master sheet' (http://www.rondebruin.nl/copy2.htm)
(Msg. 3) Posted: Thu Sep 10, 2009 1:31 pm
Post subject: RE: Multiple Worksheets, multiple lines and summarizing into one works [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Another solution may be to try Consolidation in the Data menu
"smiley61799" wrote:
> I am working with a spreadsheet which can have multiple spreadsheets all
> formatted the same way. Now although these sheets are all formatted the same
> way some may have 1 row of data while another may have 10 rows of data. I am
> wanting to incorporate these into a summary worksheet at the beginning of my
> spreadsheet which will list all of these rows automatically. What kind of
> table or formula would I need to look into to make this happen?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum