sbjmsoules
New Member
- Joined
- Aug 12, 2014
- Messages
- 1
Search dynamic File Name and pull data from multiple sheets, same cell, into one master sheet
I have a user group of approx 100 people that is required to fill out time sheets weekly. The have to submit their timesheets in with a specific naming nominclature in a network folder. I want to have a master sheet pull from this folder and populate the calculated number of hrs from a specific cell in each sheet and have it updated weekly.
I think I can use something like this to populate the Master sheet:
=INDIRECT("'[\\Management Team\Field\TimeSheets\Time-Sheets-Central]"&B18&"-TS-"&$D$17&$E$2)
Where as B18 = the persons name and $D$17 = the name of the week in the file name and $E$2 = Calculated hrs from the cell in the sheet.
I can not get it to work. It comes up with various Reference errors. Any ideas?
I think I can use something like this to populate the Master sheet:
=INDIRECT("'[\\Management Team\Field\TimeSheets\Time-Sheets-Central]"&B18&"-TS-"&$D$17&$E$2)
Where as B18 = the persons name and $D$17 = the name of the week in the file name and $E$2 = Calculated hrs from the cell in the sheet.
I can not get it to work. It comes up with various Reference errors. Any ideas?
