Create an annual summary chart based on expiry dates from another sheet?
Hi...I'm a new member and I have pretty basic Excel knowledge. I've never dealt with Excel macros or VBA codes. My problem may have a very simple solution...but it alludes me at the moment.
I am trying to simplify an existing spreadsheet that I update on a daily basis to track Tenant Insurance information and expiry dates. From that information, I need to create a seperate sheet to summarize all the expiration dates for the entire year in an easy to read version for the Landlord.
Is there an easy formula that I can input to have the expiry date information populate automatically under the month that it will expire?
I've attached a few screen shots. Hope you can help! Thanks in advance! (and sorry for the poor quality screen shots!)
Video Tutorials / Excel Dashboards Reports