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.

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.

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

Andy.

"Anne Troy" wrote in message
news:9e237$42cd7efc$97c5108d$11061@allthenewsgroup 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.

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:9e237$42cd7efc$97c5108d$11061@allthenewsgroup 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.