Display data from one tab as merged cells on another tab of workbook

[ajrilo]

Hello,



On my tracker I have two sheets, ( schedule, calendar view) on the schedule sheet the different sections simply enter section number, start and end date, event. I manually move all that to the calendar view sheet to get a quick snap shot over the years(s) . I shortened the calendar for this example , but it will continue for several years. Is there a way to have excel automatically move data to the correct area of the calendar view sheet and be displayed just like I am manually doing?

As you can see on the calendar view sheet I have merged cells and placed the events from the schedule sheet under the correct section. (1-1 means section 1 tm 1, 3-2 means section 3 tm 2, ect.)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Display data from one tab as merged cells on another tab of workbook - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[ajrilo]

My apologies, I have gone over the forum rules again and will comply!

 

[ajrilo]

I have been playing with Gantt charts, is there a way to tie a pivot table to a Gantt chart? I will only have 20 lines of info I am tracking and most of the entries will be multiple entries from the same teams I am tracking and I would just like the entries of the same teams to be displayed on the same line in the Gantt chart.