A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Consolidating sheets



 
 
Thread Tools Display Modes
  #1  
Old July 7th, 2005, 08:01 PM
external usenet poster
 
Posts: n/a
Default Consolidating sheets

Hi

We are buying a company and I need to create a stock spreadsheet from their
workbook. I would like a single sheet containing the information from about
25 of their sheets. They have one sheet per type of stock item (all in one
book), so some of their sheets have 1 row and some have 50! Bearing in mind
that some of the rows are hidden (which I don't want) what is the easiest
way to consolidate their information into a single sheet, containing all of
the info from the individual sheets?
Cheers.
Andy.


Ads
  #2  
Old July 7th, 2005, 08:14 PM
Anne Troy
external usenet poster
 
Posts: n/a
Default

Perhaps something like this, Andy?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


Andy wrote in message ...
Hi

We are buying a company and I need to create a stock spreadsheet from

their
workbook. I would like a single sheet containing the information from

about
25 of their sheets. They have one sheet per type of stock item (all in one
book), so some of their sheets have 1 row and some have 50! Bearing in

mind
that some of the rows are hidden (which I don't want) what is the easiest
way to consolidate their information into a single sheet, containing all

of
the info from the individual sheets?
Cheers.
Andy.




  #3  
Old July 7th, 2005, 08:21 PM
external usenet poster
 
Posts: n/a
Default

Thanks, Anne. I'll give it a go!

Andy.

"Anne Troy" wrote in message
news:[email protected] s.com...
Perhaps something like this, Andy?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


Andy wrote in message ...
Hi

We are buying a company and I need to create a stock spreadsheet from

their
workbook. I would like a single sheet containing the information from

about
25 of their sheets. They have one sheet per type of stock item (all in
one
book), so some of their sheets have 1 row and some have 50! Bearing in

mind
that some of the rows are hidden (which I don't want) what is the easiest
way to consolidate their information into a single sheet, containing all

of
the info from the individual sheets?
Cheers.
Andy.






  #4  
Old July 7th, 2005, 08:57 PM
external usenet poster
 
Posts: n/a
Default

Hi

I've tried that but it includes the hidden rows - which I don't want! Andy
ideas?

Andy.

Andy wrote in message ...
Thanks, Anne. I'll give it a go!

Andy.

"Anne Troy" wrote in message
news:[email protected] s.com...
Perhaps something like this, Andy?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


Andy wrote in message ...
Hi

We are buying a company and I need to create a stock spreadsheet from

their
workbook. I would like a single sheet containing the information from

about
25 of their sheets. They have one sheet per type of stock item (all in
one
book), so some of their sheets have 1 row and some have 50! Bearing in

mind
that some of the rows are hidden (which I don't want) what is the
easiest
way to consolidate their information into a single sheet, containing all

of
the info from the individual sheets?
Cheers.
Andy.








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidating multiple sheets Phil Osman General Discussion 4 June 30th, 2005 02:11 AM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Worksheet Functions 1 March 15th, 2005 05:49 PM
Sorting multiple sheets DrewM General Discussion 1 October 20th, 2004 01:05 AM
(`._.[ Extract Data From Multiple Sheets ]._.) hyperdreamz General Discussion 1 September 29th, 2004 04:03 PM
Protecting sheets but allowing them to be accessible... Colin Hayes Worksheet Functions 12 August 27th, 2004 03:49 PM


All times are GMT +1. The time now is 02:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.