I'm new to VBA and need some help. I've been able to write a script that will open a workbook based on the value of a cell and the predefined path to the workbook, get a piece of data and close the workbook and paste the value in a cell in the original workbook.
1. I would like to get it so the macro doesn't open the workbook to get the data as there will be about 40 cells worth of data to retrieve per "job number".
2. I can't figure out how to write the code so it does the entire range A2:A1500 without have a block of code for each cell. When I make it a range it puts the same data in all the cells in column M instead of referencing the job number from column K
Please note that in the example workbook I have attached (hopefully), the sheet named RTR1 is a copy from a workbook named 4819.xls
Maybe I'm going about this all wrong, but if anybody could please help it would be greatly appreciated.
Josh
Bookmarks