How do I set up a function that skips a cell in a fill?
Tammy--
I believe Mr. Phillips' solution with the custom list will work. You
can set up a custom list for Monday thru Friday. When there is a
holiday on Monday, manually input Tuesday in one cell and enter the
lesson number in the cell in the next column. Then you pull down the
fill handle. Likewise when there is a holiday on another day of the
week. This is not a perfect solution in terms of no manual entries
but it will still save you time.
I prepared the following list with just a couple of manual entries
after I created a cuutom list for Monday thru Friday.
Monday Lesson 1
Tuesday Lesson 2
WednesdayLesson 3
Thursday Lesson 4
Friday Lesson 5
Tuesday Lesson 6
WednesdayLesson 7
Thursday Lesson 8
Friday Lesson 9
Tuesday Lesson 10
WednesdayLesson 11
Thursday Lesson 12
Friday Lesson 13
Monday Lesson 14
WednesdayLesson 15
Thursday Lesson 16
Friday Lesson 17
Monday Lesson 18
Steve G
|