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
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