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

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