How to build a consolidated calendar from many other sheets.
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?
Answers
-
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!'"
================================================
"Nothing is impossible. The word itself says 'I'm possible!'"
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives