How to build a consolidated calendar from many other sheets.

vanstadenster

Hi

I am currently developing departmental marketing calendars with a team for different portfolio's. For example we have events, B2B, B2C, Digital. Each calendar has past and active/upcoming items.

My ultimate goal is to get all the data from the calendars and pull it onto a consolidated calendar for the whole department.

What I started doing was using cell linking to feed it into the "master calendar" however I feel my logic may be flawed as this will require ongoing linking as things are added and changed to remain up to date.

Has anyone done something similar and could maybe advice me on a better approach to achieve building a master calendar, getting data from many sheets?

JBG

Hi @vanstadenster

I assume the events, B2B, B2C, Digital, are all seperate sheets that you have created. Do these sheets all have the same fields, at least those you would like to filter?

If they all have the same fields, creating a report, using multiple sheets should do the job.

==============================================

"Nothing is impossible. The word itself says 'I'm possible!'"

vanstadenster

Hi

Yes, I have set them up to have the same data structure for the 1st 6 columns so we can get the info into a marketing calendar. What data would the report give me? To date I have only used them for in progress, overdue etc.

I am sure they are far more valuable than that though. Will give it a go.