Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Macro? | Excel Worksheet Functions | |||
Macro - Vlookup | Excel Discussion (Misc queries) | |||
Vlookup Macro | Excel Discussion (Misc queries) | |||
vlookup macro | New Users to Excel | |||
VLOOKUP in a macro?? | Excel Discussion (Misc queries) |