View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C C is offline
external usenet poster
 
Posts: 61
Default Fill in Date based on E1

I have a date (MMM YY) entered into cell E1. I would like to increment by
month F1 Thru whenever data is no longer populated in row 2.

My Current spreadsheet:

E F G H I
Row1 Jun 10
Row2 $80 $1600 $1706 $272 $352


How I need to modify:
E F G H I
Row1 Jun 10 Jul 10 Aug 10 Sep 10 Oct 10
Row2 $80 $1600 $1706 $272 $352

The Data in Row 2 may extend to any column.

Any help is greatly appreciated.