View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Drew[_2_] Drew[_2_] is offline
external usenet poster
 
Posts: 22
Default auto fill rows with months based on cell value

Hello All ...

I am building a basic contract tracker spreadsheet.

In one cell I enter the start date and another the number of months of the
contract.

Currently I manually enter the first month (formated Mar-08) in the first
row then manually drag-fill it down to fill the corresponding number of
months of contract.

Is there a way to have Excel 2007 automatically fill this column with the
months based on the value of start date and number of months?

Thank you.