find across multiple sheets
 

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

find across multiple sheets
 

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)

"me1" wrote in message
...
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