I homeschool my children and am in the process of setting up a grading book
for the year. I've got all my averages down, no problem. What I am having a
problem with is adding the lesson numbers or number/letter combination.
Instead of having to type each one in (Lesson 1, Lesson 2, etc) I would like
to have it auto populate the cells. When I type "Lesson 1" in the first
cell, I need it to fill in the "Lesson 2", "Lesson 3", etc.

With another book, the lessons are numbered and lettered. The first lesson
is 1A, 1B, 1C, then goes to 2A, 2B, 2C, etc.

Does anyone know how to make this happen?? I would appreciate any help
anyone can give... this is driving me nuts!!! LOL

Thanks so much!