How to overlay Team Vacation Planner into my Project Plan?

Options

Hi,

I have 2 separate spreadsheets, a Project Plan and a Team Vacation Planner. Is there anyway I can incorporate the Team Vacation Planner with all the team members holidays into the Project Plan without having to retype all the holiday dates into the project plan?

Plus, anytime the Team vacation planner changed, this would be updated and referenced in the Project Plan? it would be great esp in gannt chart view to see the project milestones and timeline against the team availabilities.


Thanks

Answers