| 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) | |||
Linear Mode
