WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Multiple Worksheets, multiple lines and summarizing into o..

 
   Home -> Office -> New Users RSS
Next:  auto fill entered data from one worksheet to anot..  
Author Message
smiley61799

External


Since: Jun 19, 2009
Posts: 3



(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?
Back to top
Login to vote
Pecoflyer

External


Since: Sep 10, 2009
Posts: 1



(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)


--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=133044
Back to top
Login to vote
Billy Liddel

External


Since: Nov 22, 2006
Posts: 255



(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?
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> New Users 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET |
  • IT Support