Hi, Hoping someone might be able to help. I'm looking to create nice calendar from a table of events/promotions. Ideally I'd like to be able to "generate" the calendar using VBA. Each product has 1 row in the Calendar but can have multiple events in the table I'd like each event to be displayed in the calendar in the appropriate row with coloured cells between the start and end dates The start date would ideally contain the description from the table (which is a combination of the other fields in the table) Any help would be greatly appreciated. Many thanks Matthew

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Event/Promotion Calendar

Thread starter Matt888
Start date May 25, 2023

Matt888

New Member

May 25, 2023

Hi,

Hoping someone might be able to help. I'm looking to create nice calendar from a table of events/promotions. Ideally I'd like to be able to "generate" the calendar using VBA.

Each product has 1 row in the Calendar but can have multiple events in the table
I'd like each event to be displayed in the calendar in the appropriate row with coloured cells between the start and end dates
The start date would ideally contain the description from the table (which is a combination of the other fields in the table)

Any help would be greatly appreciated.

Many thanks
Matthew