Lookup in multiple sheets

[yusufz]

Hi,

I need to create a macro to automate a manual task but i'm not getting anywhere!

I need to lookup the value of 1 column in 1 sheet into another workbook which contains around 20sheets. Then i want the findings to be presented in another worksheet - simply just showing the values looked up and what it found.

Is this possible? any help would be much appreciated.

thanks in advance.

[VBA Noob]

Download Flexfind from here.

Enter the text and set to search all workbooks and then click list

http://www.jkp-ads.com/download.asp


VBA Noob

[VBA Noob]

yusufz,

Please read forum rules and message to cross posters and then add the link to the other forum

VBA Noob