So I am trying to get my sheet2 to auto fill from information on sheet 1. If the location is brisbane and the date is 10/01/15 i want the ADD value to appear in the desired location.
I did example for brisbane 10/01/2015 but if you look at a more complex location/date like almost any fresno etc how can i make this auto fill and go month to month?
Bookmarks