Lookup data from multiple sheets

D

Denisa

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/
 
S

sanskar_d

Denisa said:
I have a workbook that contains about 90 worksheets that represen
business
units. I would like to create a summary page where there is going to b
be
compiled data from each worksheet. Something like a lookup in multipl
sheets/
Click to expand...


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 [email protected]

Regards,

Sa
 
Top