HOW TO i HAVE OTHER CELLS GENERATE CONSECTUIVE MONTHS

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

Guest

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,
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I put a Month into a cell and have the cells below change 1
Subtract 1, 2 and 3 months from the text "September" 8
Monthly Percent Increase 1
Month function 1
Sort pivot table field (droplist) by month or original data 1
Dynamic Formula Generation 1
Cell to return present month 4
Mapping strings to integers 5

Back
Top