how to get the data pulled from multiple sheets?

all4excel · 08-27-2007, 02:42 PM

Lets say i have 10+1 sheets from 1,2,3,4,5,6,7,8,9,10 and Search.

I type something in the Search sheet which can be in any sheet from 1 to 10 or even in one or more or all the Sheets, then how do you pull the data.

Just an hypothetical example which i can implement in my research work.

Lets say i have a some information which can repeat in any of the sheets then what i would like is to have all the information from different sheets placed one below the other till there is no more information on the same.

can u please attach an file if anyone has it understood.

It's like a multilookup from multisheets.

Is there any hitch in this ?

all4excel · 08-29-2007, 02:11 PM

attachment below

**Dav** · 08-29-2007, 03:42 PM

It can be done, probably easiest with a macro.

But a few questions first

does apple have to match exactly? eg would you want apples returned as well
Is the column always B?
Is the data to be returned just in C and D?

Regards

Dav