Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating multiple sheets | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) |