mpmcarthur
New Member
- Joined
- Oct 1, 2012
- Messages
- 9
I have a folder for each month of the year. Within each month folder, workbooks are saved with the file name "lastname mm-dd-yy.xlsm". As you can see, the file name varies depending on the user and the date. From these source workbooks, I am interested the values in two different cells.
I would like to create a summary workbook where I can put the "lastname" and date in a cell, which will then look to the corresponding source workbook. Imagine row 1 has the dates going across (B1 = "03-01-13", C1 = "03-02-13", D1 = "03-03-13", etc). Imagine column A contains the lastnames (A2 = Person1, A3 = Person2, A4 = Person3, etc). Therefore, the value in cell B2 will look to the March folder (because the date in B1 starts with 03 which is March), find the workbook called "Person1 03-01-13.xlsm", then return the value in a specified cell (i.e. the cell reference will always be fixed, such as H5). As you can see, the macro needs to look at the values in column A and row 1 determine the source workbook name that I'm interesting in retrieving values from.
Hopefully this makes sense. I appreciate any help offered.
I would like to create a summary workbook where I can put the "lastname" and date in a cell, which will then look to the corresponding source workbook. Imagine row 1 has the dates going across (B1 = "03-01-13", C1 = "03-02-13", D1 = "03-03-13", etc). Imagine column A contains the lastnames (A2 = Person1, A3 = Person2, A4 = Person3, etc). Therefore, the value in cell B2 will look to the March folder (because the date in B1 starts with 03 which is March), find the workbook called "Person1 03-01-13.xlsm", then return the value in a specified cell (i.e. the cell reference will always be fixed, such as H5). As you can see, the macro needs to look at the values in column A and row 1 determine the source workbook name that I'm interesting in retrieving values from.
Hopefully this makes sense. I appreciate any help offered.
