Macro to insert blank row until match

[twildone]

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>

 

[Tom Urtis]

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.