View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Myrna Rodriguez[_3_] Myrna Rodriguez[_3_] is offline
external usenet poster
 
Posts: 6
Default VBA Macro for VLOOKUP

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 ***