repeating a data pattern in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top