LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Filling in a Date Series using the Fill | Series menu command

Using the Fill | Series dialog box, I want to fill in a series of dates, by
month, where I know the beginning date, the end date, and the number of
months. The 'Stop Value' box is only allowing me to enter a date string
(e.g. '12/31/2005'). Instead, I want to enter in a cell reference, to a cell
that has the end date. Is there a way, or a way to write a macro that will
fill in the series, referencing begin dates and end dates contained in other
cells?
 
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
Fill date series in table Sunday School Secretary Excel Worksheet Functions 2 January 1st 10 03:04 PM
Fill date series Jessica Excel Discussion (Misc queries) 2 December 12th 08 01:25 AM
weekday and date series fill Teacher_Becky New Users to Excel 4 July 30th 08 12:20 PM
Fill Series Dates: not letting me change the series from year to m Mike Excel Discussion (Misc queries) 1 January 24th 08 05:08 PM
How do I make the "series" option available under the Fill Menu? chris j Excel Discussion (Misc queries) 1 December 14th 07 05:13 PM


All times are GMT +1. The time now is 07:19 AM.

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"