Newbie
Is there an action to automatically fill a series of dates?
Row A1 01/01/2006
Row B1 Blank
Row C1 01/02/2006
Row D1 Blank
Row E1 01/03/2006
etc.
Thanks for any help
RagDyeR - 02 Jan 2006 18:01 GMT
Simply select A1 to D1,
Right *OR* left click on the fill handle of the selection,
And drag right.

Signature
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
Newbie
Is there an action to automatically fill a series of dates?
Row A1 01/01/2006
Row B1 Blank
Row C1 01/02/2006
Row D1 Blank
Row E1 01/03/2006
etc.
Thanks for any help
bpeltzer - 02 Jan 2006 18:08 GMT
Fill in the first cell. Then select the first TWO cells (1/1/06 and blank).
Grap the fill handle at the extreme lower right of the selected cells and
drag until you've reached the ending cell (the tip will show you the value of
the latest cell you've covered).
> Newbie
>
[quoted text clipped - 8 lines]
>
> Thanks for any help
WmBrown - 02 Jan 2006 18:13 GMT
Sorry
The entries are in a column.
A1 01/01/2006
A2 Blank
A3 01/02/2006
A4 Blank
A5 01/02/2006
etc.
Will that make your answer change?
> Newbie
>
[quoted text clipped - 8 lines]
>
> Thanks for any help
RagDyeR - 02 Jan 2006 18:18 GMT
No !
Just select A1 to A4,
And drag down to where ever.

Signature
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
Sorry
The entries are in a column.
A1 01/01/2006
A2 Blank
A3 01/02/2006
A4 Blank
A5 01/02/2006
etc.
Will that make your answer change?
> Newbie
>
[quoted text clipped - 8 lines]
>
> Thanks for any help