find across multiple sheets

[me1]

Hi,
I have data in a Summary Sheet column A (about 1000 rows) and several other
sheets with some of the same data. I need to find the first match in the the
other sheets and place what is in column B next to the same found data in
the summery sheets.

Summary
A...........B
FA
VB
EG


sheet1
A............B
EG...........4
FA...........10


Sheet2
A............B
VB...........5
EG
FA


Result in Summery after running the macro
A............B
FA...........10
VB...........5
EG...........4


Thank you for your help
Andonny

 

[Bob Phillips]

Take a look at the Jan Karel Pieterse's FlexFind utility at
http://www.bmsltd.ie/MVP/Default.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)