VBA To create individual timetables from 1 master timetable

[lewdow]

Hi,

I have a master timetable for interviews which involves 6 assessors and 6 candidates showing the room, the activity, the assessor and the candidate at a particular time.

What I would like is the ability to take the master timetable and automatically be able to generate 12 personal timetables - a personal timetable for each assessor and a personal timetable for each candidate.

Has anyone had any experience of doing this before/can anyone help with a way to do it? At the moment I have a blank slate - any ideas would be greatly appreciated!

Thanks

Lewis

 

[Andrew Poulsom]

Can't you just AutoFilter by assessor or candidate?