Quote Originally Posted by Pianoman23 View Post
I'm not quite understanding the need for the "Groups" sheet.

Am I right in assuming that you want to do all the placing of Users into Sections on the Section Master Sheet and then have that information transferred to the individual Section Master sheets?

It's quite difficult to understand what you're trying to do when there is no sample data on the sheet.
The 'Groups' Sheet is not really needed, Just used for us for reference.

and you are right in what you are saying.

I'm wanting to fill out the MASTER sheet with all the user's we have.
Then I can say print out the Group 3 & the Group 3 manager knows where to send his staff.

So, If you say for example.. I'm in charge of Group A, I plan ALL the groups out on the MASTER sheet, I then print out each individual sheet and give Group A sheet to me, Group B to that section Manager and so on.
Then each 'Group Manager' knows where to send their staff.

It just save's us filling out 10 sheets when we can fill out 1 !

Anyways, I've updated the example file to hopefully make it easier to understand.

(Can be downloaded here)