View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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?