Hello everyone,
I am trying to build an Excel-timesheet. For this timesheet I want to show just the weeks that aren't filled out and the current week.
Please have a look at the attached example sheet, it will make it clearer.
I was thinking about having a macro or function that allows me to enter something like:
"if the cell in the same row, column B equals "Hours" AND cells D"rowindex":J"rowindex" are NOTEQUAL "", then hide this row and the row above"
and also:
"hide all future weeks"
It doesn't necessarily have to be a macro or something, if anyone has a better idea, go ahead.
Thx alot in advance and
kind regards.
Bookmarks