Hi Guys,
I have searched the internet, but can't seem to find a way to do what I need.
What I am looking at creating is a document with a calendar on one tab and a data sheet on another.
The data sheet would be something like:
Company | $$ | Recurring? | How often? | Start Date |
Optus |$100| Y | Last day of every month| 10/10/14
Electricity| $200| Y | Every 3 months | 11/10/14
Gym | $15 | Y | Every 7 days | 9/10/14
Bike |$300| N | | 20/10/14
ETC.
And what I want to achieve is the calendar updating automatically.
Any help would be appreciated. Trying to set up something for my dad to get all of his affairs in order.
Cheers!!
I have searched the internet, but can't seem to find a way to do what I need.
What I am looking at creating is a document with a calendar on one tab and a data sheet on another.
The data sheet would be something like:
Company | $$ | Recurring? | How often? | Start Date |
Optus |$100| Y | Last day of every month| 10/10/14
Electricity| $200| Y | Every 3 months | 11/10/14
Gym | $15 | Y | Every 7 days | 9/10/14
Bike |$300| N | | 20/10/14
ETC.
And what I want to achieve is the calendar updating automatically.
Any help would be appreciated. Trying to set up something for my dad to get all of his affairs in order.
Cheers!!