I'm working with excel 2010,
I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.
The numeric values of the second table are entirely dependant of the value of its master cell which is H 18. So the only important cell here is H18. Above cell H18 is another cell (F13) containing another date.
The goal is to be able to change the date in cell F13 and that the data belonging to this date written in the calender will be copied automatically into cell H18.