See http://www.ozgrid.com/VBA/VlookupAllSheets.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Radhakant Panigrahi" wrote in message
...
i have data in 10 different sheets (Sheet 2 to Sheet11)with identical
columns.
i need to use the vlookup function in Sheet1 taking the range from column
E
to H from each sheet.

Is there any tool whereby i can make te vookup function once for all
sheets
and need not to use it for 10 times.

regards