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. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
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 |