Dear All,
I would like to make a timetable. I have thousand different places and I want to connect these places with dates.
I would like to create a matrix and when I put an "X" somewhere in the matrix I want to command to Excel to find the value.
I attached a photo as an example:
Anna, Albert, Joe and Bea is 4 different people. They have to go to the doctor between 26/07-29/07. When they put an "X" in the matrix the Excel automatically fill the B column (when) with the date, which is in the first row.
Is there any opportunity to do this?
Thank you in advance for your help.
Bookmarks