LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Macro to insert rows at varied locations

I have a spread sheet with hundreds of entries as follows (similar, 4 columns)

[A] [b] [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] [b] [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. Im strong with
most things on excel, but I just started using macros.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows with condition using macro Shazza Excel Discussion (Misc queries) 6 September 5th 08 12:06 AM
Insert rows macro. Johnny Excel Discussion (Misc queries) 2 November 13th 07 08:38 PM
Insert Rows Macro A.S. Excel Discussion (Misc queries) 7 October 31st 07 02:03 PM
Excel Macro to insert rows Dhawal Excel Discussion (Misc queries) 3 October 2nd 06 01:16 AM
asking again, macro to insert rows Luke Excel Worksheet Functions 12 September 18th 05 06:32 PM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"