H
Hott_Mutt
I have a spread sheet with hundreds of entries as follows (similar, 4 columns)
[A] [C] [D]
Pour No. Date Description Test Result
1 Jun. 2, 08 Column F3 1032.23
2 Jun. 4, 08 Footing G1 2226.35
3 July 8, 08 Slab 1a 7892.45
3 July 8, 08 Slab 1b 4978.58
3 July 8, 08 Slab 1c 1354.54
4 July 25, 08 Footing H 7896.11
5 Aug 17. 08 Column 6a 1273.99
5 Aug 17. 08 Column 6b 3664.99
6 Sep. 1, 08 Footing J 1244.98
7 Sep. 16, 08 Footing P 1005.63
8 Sep. 23, 08 Slab 3a 1004.88
8 Sept. 23, 08 Slab 3b 7715.13
Notice for example that pour #3 is associated with three different test
results on the same day. So the values are not unique in column [A], but
pours always happen on the same day.
I need a macro that will insert a row (and another to remove them) that
identify cutoff periods. These cut offs are specific dates that vary each
time (not always the first and last day of each month). I specify myself
what dates these are.
[A] [C] [D]
Pour No. Date Description Test Result
1 Jun. 2, 08 Column F3 1032.23
2 Jun. 4, 08 Footing G1 2226.35
_________________JUNE CUT OFF_____________________________
3 July 8, 08 Slab 1a 7892.45
3 July 8, 08 Slab 1b 4978.58
3 July 8, 08 Slab 1c 1354.54
4 July 25, 08 Footing H 7896.11
5 Aug 17. 08 Column 6a 1273.99
_______________JULY AND AUGUST CUT OFF__________________
6 Sep. 1, 08 Footing J 1244.98
7 Sep. 16, 08 Footing P 1005.63
8 Sep. 23, 08 Slab 3a 1004.88
8 Sept. 23, 08 Slab 3b 7715.13
___________________SEPTEMBER CUT OFF______________________
I need the macro to insert (and remove) the cutoff row at the same specific
location (identified by date or Pour #) each time I use it.
I want the inserted rows to have varied text/title per cutoff.
Please help. I tried to be very clear with my description. I’m strong with
most things on excel, but I just started using macros.
[A] [C] [D]
Pour No. Date Description Test Result
1 Jun. 2, 08 Column F3 1032.23
2 Jun. 4, 08 Footing G1 2226.35
3 July 8, 08 Slab 1a 7892.45
3 July 8, 08 Slab 1b 4978.58
3 July 8, 08 Slab 1c 1354.54
4 July 25, 08 Footing H 7896.11
5 Aug 17. 08 Column 6a 1273.99
5 Aug 17. 08 Column 6b 3664.99
6 Sep. 1, 08 Footing J 1244.98
7 Sep. 16, 08 Footing P 1005.63
8 Sep. 23, 08 Slab 3a 1004.88
8 Sept. 23, 08 Slab 3b 7715.13
Notice for example that pour #3 is associated with three different test
results on the same day. So the values are not unique in column [A], but
pours always happen on the same day.
I need a macro that will insert a row (and another to remove them) that
identify cutoff periods. These cut offs are specific dates that vary each
time (not always the first and last day of each month). I specify myself
what dates these are.
[A] [C] [D]
Pour No. Date Description Test Result
1 Jun. 2, 08 Column F3 1032.23
2 Jun. 4, 08 Footing G1 2226.35
_________________JUNE CUT OFF_____________________________
3 July 8, 08 Slab 1a 7892.45
3 July 8, 08 Slab 1b 4978.58
3 July 8, 08 Slab 1c 1354.54
4 July 25, 08 Footing H 7896.11
5 Aug 17. 08 Column 6a 1273.99
_______________JULY AND AUGUST CUT OFF__________________
6 Sep. 1, 08 Footing J 1244.98
7 Sep. 16, 08 Footing P 1005.63
8 Sep. 23, 08 Slab 3a 1004.88
8 Sept. 23, 08 Slab 3b 7715.13
___________________SEPTEMBER CUT OFF______________________
I need the macro to insert (and remove) the cutoff row at the same specific
location (identified by date or Pour #) each time I use it.
I want the inserted rows to have varied text/title per cutoff.
Please help. I tried to be very clear with my description. I’m strong with
most things on excel, but I just started using macros.