I am trying to create a daily budget tracker with separate tables for each month, which I have created. I now want a front/first table to show:
- the balance as at today's date
- the amount spent today (if any)
- and maybe the balance tomorrow (not too bothered about this one if too difficult).
I would like to say 'if 'January 2016::A1 = TODAY(), January 2016::E1 or if January 2016::A2 = TODAY(), January 2016::E2 and so on looking at each date value across all tables in columns A and when it finds today's date to enter the value in the corresponding E column.
Hopefully this is possible?