two problems - referencing a cell in a "previous" worksheet, and automatically naming a worksheet to
Posted by Aaron on September 14, 2001 6:11 AM
Hi, my problem may seem rather remedial to some of you, but I haven't been able to figure it out so here goes:
I use Excel for my weekly timesheet at work. I enter my hours and it automatically calculates my daily and weekly totals, etc. I use a separate sheet in the same workbook for each week. On the header is the starting date (Monday) and the ending date (Sunday) of that week. The Sunday date is simply a formula which adds 6 to the Monday date. What I'd like to do though, is have the cell containing the Monday date look at the "Previous" sheet in the workbook, at the Sunday date, and add one to it. I don't know the code for "previous sheet". Obviously I want the same formula to work in every sheet, so I can't call the Previous sheet by name, since the name of each sheet is different.
Which segues nicely into the second part of my problem. I name each worksheet to match the date in the Monday cell. Is there a macro to do that automatically for me (look at the contents of a cell and rename that worksheet to match those contents)?
Thanks for any help,