lpking2005
Board Regular
- Joined
- Mar 21, 2011
- Messages
- 140
hi,
I have 2 workbooks. In my main workbook, i have one cell which which pulls a value from another cell in another workbook via vlookup.
The workbook im pulling from is named "403 Time Sheet 201109"
each month we create a new timesheet from a template, which just creates a new file and changes the date in the filename.
Is there a way i can tell the cell in my main workbook to always look into the current month timesheet and then pull the value from a cell on a certain sheet.
Many Thanks!
I have 2 workbooks. In my main workbook, i have one cell which which pulls a value from another cell in another workbook via vlookup.
The workbook im pulling from is named "403 Time Sheet 201109"
each month we create a new timesheet from a template, which just creates a new file and changes the date in the filename.
Is there a way i can tell the cell in my main workbook to always look into the current month timesheet and then pull the value from a cell on a certain sheet.
Many Thanks!
