Hi:
Thanks for looking and please help if you understand my situation.
I have one master Excel workbook.
I need to VLOOKUP values (one column) in 50 individual Excel workbooks.
So: Column A in master Excel workbook will need to vlookup in ALL 50
workbooks to return value in Column B.
Example: Column A Columb B
1 will need to vlookup in all 50 workbooks
2 will need to vlookup in all 50 workbooks
3 will need to vlookup in all 50 workbooks
and so on......
How can I automate this to save keystrokes and mouseclicks.
happy day!
*** Sent via Developersdex
http://www.developersdex.com ***