Sorry I have to detail my question further.
My real question is that in the following attached file, how to create one Macro in Excel to add one row after each row which contains 2004 and copy the format of the row which contains value 2004 to the newly added row? The cell below 2004 should be changed to 2005.
Please be careful that the value below the row contain 2004 is the sum from Prior to 2004. Is possible to change the sum range including 2005?
Thank you very much.
Dennis
Commercial Voluntary
BI PD TOTAL
Prior 0 0 0
1995 0 0 0
1996 0 0 0
1997 0 0 0
1998 0 0 0
1999 0 0 0
2000 0 0 0
2001 0 0 0
2002 0 0 0
2003 0 0 0
2004 0 0 0
0 0 0
Private Passenger Voluntary
BI PD TOTAL
Prior 0 0 0
1995 0 0 0
1996 0 0 0
1997 0 0 0
1998 0 0 0
1999 0 0 0
2000 0 0 0
2001 0 0 0
2002 0 0 0
2003 0 0 0
2004 0 0 0
0 0 0
My real question is that in the following attached file, how to create one Macro in Excel to add one row after each row which contains 2004 and copy the format of the row which contains value 2004 to the newly added row? The cell below 2004 should be changed to 2005.
Please be careful that the value below the row contain 2004 is the sum from Prior to 2004. Is possible to change the sum range including 2005?
Thank you very much.
Dennis
Commercial Voluntary
BI PD TOTAL
Prior 0 0 0
1995 0 0 0
1996 0 0 0
1997 0 0 0
1998 0 0 0
1999 0 0 0
2000 0 0 0
2001 0 0 0
2002 0 0 0
2003 0 0 0
2004 0 0 0
0 0 0
Private Passenger Voluntary
BI PD TOTAL
Prior 0 0 0
1995 0 0 0
1996 0 0 0
1997 0 0 0
1998 0 0 0
1999 0 0 0
2000 0 0 0
2001 0 0 0
2002 0 0 0
2003 0 0 0
2004 0 0 0
0 0 0