Find and Display

S

Soniya

Hi All,

I have 12 sheets with several columns of data.

I want to search for an item in column A starting from
First sheet and if the item found then display in a
message box or in a new sheet the data label(for column
A,C,F,K,L) and corresponding data (for selected fields)
or proceed to the next sheet until the item is found. the
data never get repeated (In column A)so there would be
only one instance of the data in column A.

How could i get this by a macro?

TIA
Soniya
 
F

Frank Stone

hi,
http://www.bmsltd.ie/MVP/
go to this site. they have a free download utility called
flexfind. it is an add-in that will do what you want. i
use it. great tool. it will search the entire workbook and
show all items found. click on one and it take you there.
:)
 
Top