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. |
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 |