LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto fill rows in Excel 2007 billclark54 Excel Discussion (Misc queries) 0 March 14th 08 01:54 PM
auto fill columns based on a selection ckane Excel Discussion (Misc queries) 1 May 4th 07 05:34 AM
Auto fill Column based on data in other columns SITCFanTN New Users to Excel 1 June 6th 06 09:04 PM
Auto-fill cell based on adjacent cell information.. sans Excel Worksheet Functions 1 October 17th 05 11:38 PM
How to auto-fill text based on text in another cell Jason Excel Discussion (Misc queries) 3 February 16th 05 08:40 PM


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"