Macro to insert blank row until match

twildone

Board Regular
Joined
Jun 3, 2011
Messages
63
Category
Program
Fiscal Year
Quarter
Unique Clients
Number of Rx
Cost
Quantity
Category
Program
Fiscal Year
Quarter
Unique Clients
Number of Rx
Cost
Quantity
Category
Program
Fiscal Year
Quarter
Number of Rx
Cost
Quantity
Strength
Paid and Unpaid
PDP PU
2004/05
1
29038
35080
1524717.48
1216934.9
Paid and Unpaid
PDP PU
2004/05
1
6713
7291
313645.18
265005.1
Paid and Unpaid
PDP PU
2004/05
1
2523
83722.67
51853.0
250MG
Paid and Unpaid
PDP PU
2005/06
1
32889
39764
1811670.02
1348258.5
Paid and Unpaid
PDP PU
2004/05
2
5808
6277
275111.43
196236.5
Paid and Unpaid
PDP PU
2004/05
1
121
7538.92
14382.5
250MG/5ML
Paid and Unpaid
PDP PU
2006/07
1
30398
36695
1744564.22
1195268.2
Paid and Unpaid
PDP PU
2004/05
3
8195
8888
385336.50
320800.3
Paid and Unpaid
PDP PU
2004/05
1
1175
37483.28
137593.5
25MG/ML
Paid and Unpaid
PDP PU
2007/08
1
28803
34597
1700581.99
1140951.3
Paid and Unpaid
PDP PU
2004/05
4
11751
12624
550624.37
434893.0
Paid and Unpaid
PDP PU
2004/05
1
3472
184900.31
61176.1
500MG
Paid and Unpaid
PDP PU
2008/09
1
21104
24634
1198106.50
966154.4
Paid and Unpaid
PDP PU
2005/06
1
8903
9554
427952.80
319158.0
Paid and Unpaid
PDP PU
2004/05
2
1992
68865.68
42792.0
250MG
Paid and Unpaid
PDP PU
2009/10
1
16737
19468
927014.81
959544.5
Paid and Unpaid
PDP PU
2005/06
2
7356
7888
361144.87
271206.0
Paid and Unpaid
PDP PU
2004/05
2
95
6051.94
11612.5
250MG/5ML
Paid and Unpaid
PDP PU
2010/11
1
16469
19140
919465.73
930672.5
Paid and Unpaid
PDP PU
2005/06
3
9647
10450
474663.09
366075.0
Paid and Unpaid
PDP PU
2004/05
2
745
23749.62
83289.0
25MG/ML
Paid and Unpaid
PDP PU
2011/12
1
13672
15873
772938.89
798988.0
Paid and Unpaid
PDP PU
2005/06
4
11045
11872
547909.26
391819.5
Paid and Unpaid
PDP PU
2004/05
2
3445
176444.19
58543.0
500MG
Paid Only
PDP
2004/05
1
4700
5924
281640.52
161506.5
Paid and Unpaid
PDP PU
2006/07
1
7395
7928
367195.08
269264.7
Paid and Unpaid
PDP PU
2004/05
3
2686
90848.98
55885.0
250MG
Paid Only
PDP
2005/06
1
5023
6342
313159.60
169564.0
Paid and Unpaid
PDP PU
2006/07
2
6020
6508
310064.64
205146.0
Paid and Unpaid
PDP PU
2004/05
3
229
14748.54
29422.0
250MG/5ML
Paid Only
PDP
2006/07
1
4741
5922
303636.14
152738.0
Paid and Unpaid
PDP PU
2006/07
3
9336
10113
476393.67
341113.5
Paid and Unpaid
PDP PU
2004/05
3
1368
44938.28
157115.0
25MG/ML
Paid Only
PDP
2007/08
1
4292
5359
280047.18
136060.0
Paid and Unpaid
PDP PU
2006/07
4
11241
12146
590910.83
379744.0
Paid and Unpaid
PDP PU
2004/05
3
4605
234800.70
78378.3
500MG
Paid Only
PDP
2008/09
1
2194
2581
134003.82
82449.0
Paid and Unpaid
PDP PU
2007/08
1
7111
7614
372240.29
244810.0
Paid and Unpaid
PDP PU
2004/05
4
3729
125313.43
76460.0
250MG
Paid Only
PDP
2009/10
1
1554
1844
93669.89
69539.0
Paid and Unpaid
PDP PU
2007/08
2
6108
6595
323103.81
209916.0
Paid and Unpaid
PDP PU
2004/05
4
332
22125.36
41650.0
250MG/5ML
Paid Only
PDP
2010/11
1
1530
1758
89845.99
63079.0
Paid and Unpaid
PDP PU
2007/08
3
8397
9026
442212.89
300899.0
Paid and Unpaid
PDP PU
2004/05
4
1819
58588.20
202628.0
25MG/ML
Paid Only
PDP
2011/12
1
1138
1319
67593.18
49808.0
Paid and Unpaid
PDP PU
2007/08
4
10595
11362
563025.00
385326.3
Paid and Unpaid
PDP PU
2004/05
4
6744
344597.38
114155.0
500MG
Paid Only
PDP Paid
2004/05
1
7969
10298
463304.94
340746.5
Paid and Unpaid
PDP PU
2009/10
1
7976
8530
426897.71
279538.0
Paid and Unpaid
PDP PU
2005/06
1
2783
94826.93
56937.0
250MG
Paid Only
PDP Paid
2005/06
1
8286
10693
499179.17
352578.5
Paid and Unpaid
PDP PU
2009/10
2
5464
5891
295040.66
194424.9
Paid and Unpaid
PDP PU
2005/06
1
303
20786.88
37015.0
250MG/5ML
Paid Only
PDP Paid
2006/07
1
7656
9825
481090.19
315629.0
Paid and Unpaid
PDP PU
2009/10
3
4728
5006
227580.47
222576.5
Paid and Unpaid
PDP PU
2005/06
1
1209
39894.31
135255.0
25MG/ML
Paid Only
PDP Paid
2007/08
1
6903
8786
444089.37
281655.0
Paid and Unpaid
PDP PU
2009/10
4
4903
5207
248587.66
269615.0
Paid and Unpaid
PDP PU
2005/06
1
5259
272444.68
89951.0
500MG
Paid Only
PDP Paid
2008/09
1
4241
5256
263633.16
218757.0
Paid and Unpaid
PDP PU
2010/11
1
4675
4915
233754.41
246796.0
Paid and Unpaid
PDP PU
2005/06
2
2291
78982.57
47443.0
250MG
Paid Only
PDP Paid
2009/10
1
3319
4061
196848.59
216101.0
Paid and Unpaid
PDP PU
2010/11
2
2868
3045
148258.68
135519.5
Paid and Unpaid
PDP PU
2005/06
2
330
21981.58
39035.0
250MG/5ML
Paid Only
PDP Paid
2010/11
1
2963
3567
176671.64
187730.0
Paid and Unpaid
PDP PU
2010/11
3
5606
5935
282456.50
292345.0
Paid and Unpaid
PDP PU
2005/06
2
987
32435.36
110416.0
25MG/ML
Paid Only
PDP Paid
2011/12
1
2320
2792
140682.54
155329.0
Paid and Unpaid
PDP PU
2010/11
4
5269
5573
262545.22
284884.0
Paid and Unpaid
PDP PU
2005/06
2
4280
227745.36
74312.0
500MG
Paid and Unpaid
PDP PU
2010/11
1
3997
4211
198584.22
197210.5
Paid and Unpaid
PDP PU
2005/06
3
2854
98293.17
58875.0
250MG
Paid and Unpaid
PDP PU
2010/11
2
3355
3534
171333.10
160849.0
Paid and Unpaid
PDP PU
2005/06
3
435
28861.96
48435.0
250MG/5ML
Paid and Unpaid
PDP PU
2010/11
3
5500
5791
278713.57
294049.0
Paid and Unpaid
PDP PU
2005/06
3
1425
47010.44
159678.0
25MG/ML
Paid and Unpaid
PDP PU
2010/11
4
5333
5604
270834.84
278564.0
Paid and Unpaid
PDP PU
2005/06
3
5736
300497.52
99087.0
500MG
Paid and Unpaid
PDP PU
2011/12
1
3544
3744
184653.51
198175.0
Paid and Unpaid
PDP PU
2005/06
4
3167
111799.60
67150.0
250MG
Paid and Unpaid
PDP PU
2011/12
2
2674
2802
137750.09
142954.0
Paid and Unpaid
PDP PU
2005/06
4
418
27689.68
47622.5
250MG/5ML
Paid and Unpaid
PDP PU
2011/12
3
4452
4711
228583.20
241744.0
Paid and Unpaid
PDP PU
2005/06
4
1409
46605.38
157890.0
25MG/ML
Paid and Unpaid
PDP PU
2011/12
4
4370
4616
221952.09
216115.0
Paid and Unpaid
PDP PU
2005/06
4
6878
361814.60
119157.0
500MG
Paid Only
PDP
2004/05
1
351
387
19037.60
10554.0
Paid and Unpaid
PDP PU
2006/07
1
1984
69121.98
41491.0
250MG
Paid Only
PDP
2004/05
2
934
1065
52299.91
29845.0
Paid and Unpaid
PDP PU
2006/07
1
264
18149.39
30473.0
250MG/5ML
Paid Only
PDP
2004/05
3
1469
1644
77580.84
48209.5
Paid and Unpaid
PDP PU
2006/07
1
1043
34692.05
117181.7
25MG/ML
Paid Only
PDP
2004/05
4
2555
2828
132722.17
72898.0
Paid and Unpaid
PDP PU
2006/07
1
4637
245231.66
80119.0
500MG
Paid Only
PDP
2005/06
1
444
478
22873.21
13236.0
Paid and Unpaid
PDP PU
2006/07
2
1609
57768.06
34408.0
250MG
Paid Only
PDP
2005/06
2
941
1046
52626.54
28989.0
Paid and Unpaid
PDP PU
2006/07
2
236
15515.50
26190.0
250MG/5ML
Paid Only
PDP
2005/06
3
1796
2042
101298.94
55529.0
Paid and Unpaid
PDP PU
2006/07
2
658
21844.10
73905.0
25MG/ML
Paid Only
PDP
2005/06
4
2510
2776
136360.91
71810.0
Paid and Unpaid
PDP PU
2006/07
2
4005
214936.98
70643.0
500MG
Paid Only
PDP
2006/07
1
358
382
19624.95
9956.0
Paid and Unpaid
PDP PU
2006/07
3
2317
81740.62
49060.0
250MG
Paid Only
PDP
2006/07
2
767
856
43104.49
22770.0
Paid and Unpaid
PDP PU
2006/07
3
388
26559.46
47467.5
250MG/5ML
Paid Only
PDP
2006/07
3
1725
1940
98821.30
50124.0
Paid and Unpaid
PDP PU
2006/07
3
1253
40371.28
136242.0
25MG/ML
Paid Only
PDP
2006/07
4
2468
2744
142085.40
69888.0
Paid and Unpaid
PDP PU
2006/07
3
6155
327722.31
108344.0
500MG
Paid Only
PDP
2007/08
1
335
369
18778.92
9981.0
Paid and Unpaid
PDP PU
2006/07
4
2541
90022.32
53503.0
250MG
Paid Only
PDP
2007/08
2
797
896
47505.13
23132.0
Paid and Unpaid
PDP PU
2006/07
4
425
29798.41
49567.0
250MG/5ML
Paid Only
PDP
2007/08
3
1534
1707
88148.84
42462.0
Paid and Unpaid
PDP PU
2006/07
4
1215
40273.37
135352.0
25MG/ML
Paid Only
PDP
2007/08
4
2172
2387
125614.29
60485.0
Paid and Unpaid
PDP PU
2006/07
4
7965
430816.73
141322.0
500MG

<TBODY>
</TBODY>

<TBODY>
</TBODY>
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,224
Wow. Perhaps for some meaningful replies from readers based on a more knowledgeable understanding of your situation, consider adding *some* text to explain what is going on, with an example of what you are talking about and your expected results based on some small portion of this huge grid you posted.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,721
Messages
5,597,758
Members
414,171
Latest member
12Rev79

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top