Im trying to create a spreadsheet that will allow me to tabulate hour totals
(which I know how to do), but also let me know the last date a process took
place. My thought was to have a second sheet with all the dates in a given 6
month period. When a process was performed I would go to that date and place
a hour total for that day in a row for that given date. My problem is making
that date show up on the first sheet (summary) of my spreadsheet, with out
manually populating it myself. So say I did 3 hours of work on 3/13/2006, I
would go to that date on my second sheet, put 3 in the 3/13/2006 column and
expect that date to show up on the front page as the last date that process
was performed. Im sure this is clear as mud, but maybe someone can help.
Thanks in advance.