Hi All,

I'm trying to create a visual roster (names down the y-axis, dates along the x-axis) for a large number of staff working different rosters? Basically I have 3 different rosters people can work (which I have placed a drop-down list next to their name incase they decided to change roster), and these rosters are 2weeks on, 1 week off starting every Monday (ie; roster 1 would start this Monday and work for the next 2 weeks before having a week off, roster 2 would be having their week off starting today before coming back for 2 weeks next monday, and roster 3 would be finishing their second week this monday before taking a week off next monday).

I have this all mapped out on another tab (different rostes down the y-axis and dates along the x-axis) and was wondering if their was someway that I could look up the particular roster next to their name and populate my table so I can scroll to any date and see how many people i've got on?

Thanks!