What I was thinking of was the way Excel lets you set up a pattern of
repeating data and use AutoFill to drag and fill cells with it. But this
probably wouldn't work here.
--
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
...
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?