View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dezzie Dezzie is offline
external usenet poster
 
Posts: 3
Default Automatically fill following cells depending on one cell.

Hello. I am creating an input area for another Excel user.

I would like A2:A10 to return the names of months in order, depending on
what month was in A1.

For example, if A1=January, then A2=February, A3=March, A4=April, etc.
But if A1=February, then A2=March, A3=April, A4=May, etc.

Is there a way to do this using IF and OR, or a simpler way?
As well, A1 is being chosen using a list. Does this complicate matters too
much, or can I leave it in? Thanks.
Thank you