The timesheet program is an excel worksheet named TimeRunn.xlsx. The timecard template program is another excel worksheet file called runneptc1.xlsx. The question comes from naming each daily worksheet for each day - ex 11-1, 11-2, 11-3. I am trying to input the days I would like to print on the weekly time cards. In order to do this the timecard file would have to pull a conditional date: ex =[TimeRunn]11-1!cell range. Is there a generic tag ( 1 or A ) or a conditional way I can tell the time card file to pull daily sheets which I can input the date on.
One possible but really inconvenient solution that I see is to name the daily sheets for the current week - Day 1, Day 2, Day 3 etc. ex. [TimeRunn]Day1!Cell range. This will allow the time card program a valid address but would require renaming the sheets each week with new names - A step which I would like to avoid if possible. Thanks for your help.
There appears to be no way on this response page to attach a file, let me know how I can forward you the files, and I will. Thanks!