Repeating text every nth cell

**DGribb** · 10-04-2011, 06:01 PM

Using Excel 2010

So here's the situation: I'm trying to set up a scheduling sheet for a business. They have customers that are serviced weekly, bi-weekly, monthly, and bi-monthly. I'm trying to figure out how I can have the text autofill in for a year's span on a calendar.

Let's work with this example:

I have Company A that will need repeat services on a bi-weekly basis. They will be on the schedule for every Wednesday for the foreseeable future. I want to be able to have their name fill in every 14 days on a calendar. I tried using autofill and have google'd for a solution for a couple of hours now to no avail.

Workbook attached if you need to fumble around with it at all. Help is very much appreciated.

Thanks

**Blake 7** · 10-04-2011, 06:06 PM

Question. What is the aim of the spreadsheet? whats the ultimate goal?

at the moment it looks that you may benefit more from using the outlook calender.

**tlafferty** · 10-04-2011, 06:07 PM

To make your autofill work properly, you need to select sufficient cells to establish the pattern. To get the full pattern, select E4:R4, then try the autofill.

**DGribb** · 10-04-2011, 06:14 PM

@Blake - Aim is to first plot out what every job looks like on the calendar, then it will be followed up by matching work crews to jobs based on their scheduling availability.

@tlafferty - I tried entering it into three places in the calendar but I'm not able to get it to fill to the end of the calendar.