View Single Post
  #1   Report Post  
KelC
 
Posts: n/a
Default repeating a data pattern in excel

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?