Compare dates and insert a missing date in a new row

yousef9 · Apr 16th, 2002, 09:01 PM

This is what I would like to do.
The first column of my spreadsheet could have text and date values; as follows:
12/5/2000
12/6/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

I would like a macro to be applied to the first column. The macro needs to realize that there is a gap in the dates after 12/6/2000 and and before 12/9/2000. I want the macro to insert the missing dates in 2 new rows
12/7/200
12/8/2000

So the spreadwheet should look like:

12/5/2000
12/6/2000
12/7/2000
12/8/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

_________________
regards-
Yousef

[ This Message was edited by: yousef9 on 2002-04-16 20:03 ]

yousef9 · Apr 16th, 2002, 09:03 PM

Quote:

On 2002-04-16 20:01, yousef9 wrote:
This is what I would like to do.
The first column of my spreadsheet could have text and date values; as follows:
12/5/2000
12/6/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

I would like a macro to be applied to the first column. The macro needs to realize that there is a gap in the dates after 12/6/2000 and and before 12/9/2000. I want the macro to insert the missing dates in 2 new rows
12/7/200
12/8/2000

So the spreadwheet should look like:

12/5/2000
12/6/2000
12/7/2000
12/8/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

_________________
regards-
Yousef

[ This Message was edited by: yousef9 on 2002-04-16 20:03 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 09:01 PM	#1
yousef9 New Member Join Date: Apr 2002 Posts: 2	This is what I would like to do. The first column of my spreadsheet could have text and date values; as follows: 12/5/2000 12/6/2000 12/9/2000 Subtotal 1/1/2001 1/2/2001 1/3/2001 subtotal GrandTotal I would like a macro to be applied to the first column. The macro needs to realize that there is a gap in the dates after 12/6/2000 and and before 12/9/2000. I want the macro to insert the missing dates in 2 new rows 12/7/200 12/8/2000 So the spreadwheet should look like: 12/5/2000 12/6/2000 12/7/2000 12/8/2000 12/9/2000 Subtotal 1/1/2001 1/2/2001 1/3/2001 subtotal GrandTotal _________________ regards- Yousef [ This Message was edited by: yousef9 on 2002-04-16 20:03 ]