Hello. How can I use a date to trigger changes in other cells for example, if A1 is the date 9/1/14 I want it to populate a cell in another tab of the sheet with data in a cell from another tab. For e.g. I enter date 9/1/14 in A1 on tab 1 and on tab 2 data from cell A2 in tab 1 populates cell A1 on tab 2. Hope that makes sense? Thanks.
Bookmarks