Hey,
I'm looking for a solution to a problem.
First I must say that I can manage a single column search matrix, but now I need to search through the cell next to weekday. This makes me end up searching match from seven columns.
I want to make a link to a cell that contains current date and current time as a value, like 43685,25 etc.
The worksheet is ment for keep track of hours spent on a project and sometimes I want to look up previous weeks, and I want a button that takes me to the cell where I'm currently at.
I provide a picture of the worksheet as an attachment.
In finnish excel function separator is ";" instead of "," - VASTINE is MATCH, OSOITE is ADDRESS, NYT is NOW.
Bookmarks