Well, I'm a little confused - are the people listed all of the people involved?

You mention team and working with others - what/who makes up a team?

For now, assuming that these are all the people involved, there is the
possibility of coming up with a macro that would randomly rearrange the
folks, making sure that one or two things don't happen in any two months:

Easy - make sure same person doesn't get the same area 2 months in a row.
More difficult - not only not the same area 2 months in a row, but not
"next" to same 2 people they were the month before.

"Ann" wrote:

Thank you for your reply. We have tried what you suggested with the perons
on our team, but the team suggested that they get to work with others so that
they can learn from them. Any suggestions to make it more random? I'm at a
loss.

"JLatham" wrote:

Without getting overly complex and trying to randomize everything and then
check for duplicate entries for 2 months in a row, how about we simply rotate
the people each month: taking the top of the list for a month and putting
that person at the bottom of the list and moving everyone else up one 'row'.

To do this with formulas, assuming "Area to Audit" is in column A and May is
in column B, then under June, put this formula next to Nancy (in May)
=B3
that should cause Ann to show up auditing East Side in June
'fill' that formula down through Metals : Sherry
Then next to Warehouse : Becky, in June column put
=B2
which should pull Nancy to the bottom of the list.

You can now fill these formulas to the right under later months and the
rotation will be done automatically for you.

Search Excel Help for "fill data" for help doing that if you're unfamiliar
with it. If the 'help' doesn't turn out to be much, then post back.

"Ann" wrote:

I have a spreadsheet I use to assign our committee audit areas. The same
group of people is rearranged and put into the other columns (per month). It
is rearranged in no particular order, but I attempt to ensure that the same
person does not have to audit the same area two months in a row. Currently,
I manually create this. It looks similiar to this:

Area to audit May June July ...
East Side Nancy
West Side Ann
South Side Joe
North Side Jamie
Office Ruth
Metals Sherry
Warehouse Becky

Is there a way to rearrange the data for each month so that I'm not spending
hours attempting to ensure that everyone is seeing each area?