Hello mv835,
This macro is basically an expanded version of Bob's. This one allows you setup the macro to retrieve the data. The data is read from the cell addresses that are in the variable AddxList. This data is then copied as a single row into the destination workbook (the workbook running the macro). You didn't say if you are using Excel 2007 or not, so you can change the file extension from "xls" to "xlsx". The source wowrksheet name is CellInfo and the summary sheet name is Sheet1. These can be changed as well. Change the file path by changing the variable FileFolder.
Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.
Sincerely,
Leith Ross
Bookmarks