HOW TO i HAVE OTHER CELLS GENERATE CONSECTUIVE MONTHS

C

Cathy in Florida

I should elaborate on my first questions. I know how to use the "fill
handle". But what I want to do is protect most of my worksheet but type in a
month e.g. "JULY" and have all the cells below that month automatically fill
in the Next Month e.g. AUGUST, SEPTEMBER, OCTOBER etc. I do not want to have
to unprotect my worksheet and use the fill handle each time.

Thanks for your help,
 
M

mrice

The sort of thing that you need could be like the following

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
ActiveSheet.Unprotect
Select Case Target
Case Is = "JULY"
Target.Offset(1, 0) = "AUGUST"
Target.Offset(2, 0) = "SEPTEMBER"
Target.Offset(3, 0) = "OCTOBER"
Case Is = "AUGUST"
Target.Offset(1, 0) = "SEPTEMBER"
Target.Offset(2, 0) = "OCTOBER"
Target.Offset(3, 0) = "NOVEMBER"
End Select
ActiveSheet.Protect
End If
End Su
 
Top