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
|
|||
|
|||
Lookup data from multiple sheets
I have a workbook that contains about 90 worksheets that represent business
units. I would like to create a summary page where there is going to be be compiled data from each worksheet. Something like a lookup in multiple sheets/ -- Denisa |
#2
|
|||
|
|||
Denisa Wrote: I have a workbook that contains about 90 worksheets that represent business units. I would like to create a summary page where there is going to be be compiled data from each worksheet. Something like a lookup in multiple sheets/ -- Denisa Hi Denisa, Try using Countif & Sumif functions for the summary sheet. Also try defining names to ranges from all sheets (Insert Name Define) I use this most of the time. Hope this solves. If not post a small example or mail me on Regards, Sam -- sanskar_d ------------------------------------------------------------------------ sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217 View this thread: http://www.excelforum.com/showthread...hreadid=380780 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Updating Excel Data on Multiple Sheets | Juana Cafe | Worksheet Functions | 3 | February 28th, 2005 09:04 PM |
(¯`·._.·[ Extract Data From Multiple Sheets ]·._.·´¯) | hyperdreamz | General Discussion | 1 | September 29th, 2004 04:03 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
Append data from multiple sheets | Terri | General Discussion | 1 | June 18th, 2004 04:57 PM |
sorting data on multiple sheets | jer | Worksheet Functions | 5 | September 30th, 2003 12:02 AM |