Forum Discussion
scheasbro
Dec 05, 2022Copper Contributor
Excel spreadsheet (list) to Calendar - auto update?
I have a spreadsheet that I use each month to track monthly bills. It is nothing more than a list with 8 columns (Paid Yes/No dropdown, Due Date, Payee, Payment Amount, Notes/Comments, Total Account Balance, Interest Rate, and Method of Payment. I use Excel 365 for Mac.
I would love to be able to pull out 3 columns of info (Due Date, Payee, Payment Amount) and have it exported to my calendar each month. Ideally, I would not have to manually export and import every month from Excel into my calendar.
The reason I want to do this is so that I can visually see and be reminded when a bill is coming due on any device that I am using at the time. I also share my calendar with my husband, and it helps us coordinate finances, big purchases, etc.
I am not a newbie to Excel (I took the intro class :oP ) but I am out of my wheelhouse with this idea. I follow instructions well if they are clearly written. 🙂
Anyone? Thank you in advance for your time and for reading this.
- peiyezhuBronze Contributorhttps://answers.microsoft.com/en-us/msoffice/forum/all/creating-an-automated-work-calendar-with-updates/0cb62dc4-db37-4ee2-9a11-0cb27623c929
visually see and be reminded?
convert list to calendar?
or convert list to ics and then import to outlook canledar or Android calendar?