[TW]

how can i do it in excel? is there a calender wizard in excel?

"Suzanne S. Barnhill" wrote:

There's no way to do this automatically in Word (as you could in Excel). I
do something similar in Word, though, that might work for you (you'd need to
modify the method). I have a situation where I have four tasks that have to
be rotated among a given number of people so that each one will do each task
at least once. This is reasonably easy to do provided the number of people
is not a multiple of four. Here's how I do it:

1. Type each name and press Enter (each name is in a separate paragraph).

2. Select the list, copy, and paste three times, so that each name appears
four times.

3. Select the new list and use Table | Convert | Text to Table, separating
at paragraph marks and specifying four columns. This places the names in a
table of four columns and as many rows as there are names.

It would take some trial and error (and logic) to figure out how to set this
up, but perhaps the Text to Table approach could also work for you.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"TW" wrote in message
...
i have five names i need to enter to work overtime for every month of the
year is there a way that i can enter the names and word will automatically
enter them in the calender and make sure that it is evenly distributed?
ex: i have bob,sue,mike,troy,and brad. bob/sue/mike are to be rotated
between 1st and 2nd shift troy and brad only needs to be rotated between
third shift. is there a way i can do this?