Im using excel to run a class register for a playgroup. Each pupil is booked
in for a number of days per week. To show their forecast for the year, I'm
manually entering the days they're going to be present each week - is there a
way to do this automatically?

For example, Ben is booked in for Mondays, Wednesday and Fridays - how can I
copy this weekly pattern throughout the year without manually tabbing across
and ticking the relevant days?

Hi, Kel. To do this manually, but easily, type the first 3 "sets". Select
them all and copy down using the fill handle. You could also type, for
instance, You could also type the date of the first M, W, F of the month,
then use a formula for others: =A1+7 to get one week later.
*******************
~Anne Troy

www.OfficeArticles.com


"KelC" wrote in message
...
Im using excel to run a class register for a playgroup. Each pupil is
booked
in for a number of days per week. To show their forecast for the year,
I'm
manually entering the days they're going to be present each week - is
there a
way to do this automatically?

For example, Ben is booked in for Mondays, Wednesday and Fridays - how can
I
copy this weekly pattern throughout the year without manually tabbing
across
and ticking the relevant days?