1st Macro - Loop - Almost There?

[northshoreroad]

Hi all

Very new to VBA and hoping the community can help

I am trying to return the top 30 results from a number of days throughout the year.

There is only one header, at least 30 rows per day and the data has already been sorted. There will be no blank cells.

[TABLE="width: 262"]
<colgroup><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Symbol[/TD]
[TD]Date[/TD]
[TD] Open [/TD]
[TD] Close [/TD]
[TD]Change[/TD]
[/TR]
[TR]
[TD]LEJU[/TD]
[TD]1/3/2017[/TD]
[TD] $ 4.70[/TD]
[TD] $ 4.20[/TD]
[TD]-10.64%[/TD]
[/TR]
[TR]
[TD]TWLO[/TD]
[TD]1/3/2017[/TD]
[TD] $ 29.25[/TD]
[TD] $ 26.50[/TD]
[TD]-9.40%[/TD]
[/TR]
[TR]
[TD]WAAS[/TD]
[TD]1/3/2017[/TD]
[TD] $ 24.15[/TD]
[TD] $ 22.06[/TD]
[TD]-8.65%[/TD]
[/TR]
[TR]
[TD]IO[/TD]
[TD]1/3/2017[/TD]
[TD] $ 6.10[/TD]
[TD] $ 5.60[/TD]
[TD]-8.20%[/TD]
[/TR]
[TR]
[TD]TSQ[/TD]
[TD]1/3/2017[/TD]
[TD] $ 10.46[/TD]
[TD] $ 9.63[/TD]
[TD]-7.93%[/TD]
[/TR]
[TR]
[TD]CNDT[/TD]
[TD]1/3/2017[/TD]
[TD] $ 14.84[/TD]
[TD] $ 13.72[/TD]
[TD]-7.55%[/TD]
[/TR]
[TR]
[TD]FN[/TD]
[TD]1/3/2017[/TD]
[TD] $ 41.05[/TD]
[TD] $ 37.98[/TD]
[TD]-7.48%[/TD]
[/TR]
[TR]
[TD]BCEI[/TD]
[TD]1/3/2017[/TD]
[TD] $ 1.05[/TD]
[TD] $ 0.98[/TD]
[TD]-6.67%[/TD]
[/TR]
[TR]
[TD]SGY[/TD]
[TD]1/3/2017[/TD]
[TD] $ 30.52[/TD]
[TD] $ 28.52[/TD]
[TD]-6.55%[/TD]
[/TR]
</tbody>[/TABLE]

The data above is for 1/3/17 until the end of the year. I would like to keep the first 30 rows, and then delete all rows until the next day (1/4/17 and so on). Once onto the next day keep/skip over the first 30 rows and then delete until the next day

Not sure how to put that into VBA language

From what I've read it would look something like this

Sub Keep_30()
I = 2 < this is where the data starts
I + 30 < skip over 30 rows
Delete until next I
End Sub

Thank you for any help you can provide

 

[shg]

Delete row 32 through the end?

Sub nsr()
  Range("A32", Cells(Rows.Count, Columns.Count)).ClearContents
End Sub

 

[northshoreroad]

Delete row 32 through the end?

Sub nsr()
  Range("A32", Cells(Rows.Count, Columns.Count)).ClearContents
End Sub

Hi shg.

Thank you for the quick reply

So my data starts on row 2. I would want to keep row 2 to row 31 and then delete all rows in between the next date. Once I get to the next date skip over 30 rows and then delete all rows after the first 30 until the next date.... and so on

I basically have hundreds of rows for 252 days of the year. I want to get it down to just 30 rows for those 252 days

 

[shg]

Post a workbook with an example that makes clear what you're trying to do.

I'm done for the evening, but someone will help you sort it out.

 

[northshoreroad]

Hey SHG

I don't currently have permission to attach a workbook.

Is there another way I could send? Or could the admins allow my account to post attachments?

I manually completed a couple of days in order to give you a sense of what I am trying to accomplish. Looks pretty bad on here but in Excel it should look good

The below shows the top 30 NYSE companies from January 1997 sorted first by date and then percentage change

Looking to keep the 30 largest losers for each day, and then delete all rows until the next day and then so on

[TABLE="width: 253"]
<colgroup><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Symbol[/TD]
[TD]Date[/TD]
[TD] Open [/TD]
[TD] Close [/TD]
[TD] Change [/TD]
[/TR]
[TR]
[TD]GVA[/TD]
[TD]1/2/1997[/TD]
[TD] $ 8.89[/TD]
[TD] $ 8.06[/TD]
[TD]-9.34%[/TD]
[/TR]
[TR]
[TD]SIG[/TD]
[TD]1/2/1997[/TD]
[TD] $ 5.21[/TD]
[TD] $ 4.79[/TD]
[TD]-8.06%[/TD]
[/TR]
[TR]
[TD]CBK[/TD]
[TD]1/2/1997[/TD]
[TD] $ 0.80[/TD]
[TD] $ 0.74[/TD]
[TD]-7.50%[/TD]
[/TR]
[TR]
[TD]SFE[/TD]
[TD]1/2/1997[/TD]
[TD] $ 59.28[/TD]
[TD] $ 55.78[/TD]
[TD]-5.90%[/TD]
[/TR]
[TR]
[TD]SF[/TD]
[TD]1/2/1997[/TD]
[TD] $ 2.26[/TD]
[TD] $ 2.13[/TD]
[TD]-5.64%[/TD]
[/TR]
[TR]
[TD]HCC[/TD]
[TD]1/2/1997[/TD]
[TD] $ 15.83[/TD]
[TD] $ 15.00[/TD]
[TD]-5.24%[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]1/2/1997[/TD]
[TD] $ 6.00[/TD]
[TD] $ 5.69[/TD]
[TD]-5.21%[/TD]
[/TR]
[TR]
[TD]HEI[/TD]
[TD]1/2/1997[/TD]
[TD] $ 2.54[/TD]
[TD] $ 2.41[/TD]
[TD]-5.04%[/TD]
[/TR]
[TR]
[TD]COF[/TD]
[TD]1/2/1997[/TD]
[TD] $ 12.00[/TD]
[TD] $ 11.41[/TD]
[TD]-4.92%[/TD]
[/TR]
[TR]
[TD]CUZ[/TD]
[TD]1/2/1997[/TD]
[TD] $ 15.13[/TD]
[TD] $ 14.39[/TD]
[TD]-4.89%[/TD]
[/TR]
[TR]
[TD]PSA[/TD]
[TD]1/2/1997[/TD]
[TD] $ 30.87[/TD]
[TD] $ 29.37[/TD]
[TD]-4.86%[/TD]
[/TR]
[TR]
[TD]PSO[/TD]
[TD]1/2/1997[/TD]
[TD] $ 13.25[/TD]
[TD] $ 12.62[/TD]
[TD]-4.75%[/TD]
[/TR]
[TR]
[TD]CRK[/TD]
[TD]1/2/1997[/TD]
[TD] $ 65.60[/TD]
[TD] $ 62.50[/TD]
[TD]-4.73%[/TD]
[/TR]
[TR]
[TD]RJF[/TD]
[TD]1/2/1997[/TD]
[TD] $ 5.90[/TD]
[TD] $ 5.63[/TD]
[TD]-4.64%[/TD]
[/TR]
[TR]
[TD]AZO[/TD]
[TD]1/2/1997[/TD]
[TD] $ 27.00[/TD]
[TD] $ 25.75[/TD]
[TD]-4.63%[/TD]
[/TR]
[TR]
[TD]AIV[/TD]
[TD]1/2/1997[/TD]
[TD] $ 28.00[/TD]
[TD] $ 26.75[/TD]
[TD]-4.46%[/TD]
[/TR]
[TR]
[TD]CVS[/TD]
[TD]1/2/1997[/TD]
[TD] $ 10.31[/TD]
[TD] $ 9.85[/TD]
[TD]-4.46%[/TD]
[/TR]
[TR]
[TD]TNC[/TD]
[TD]1/2/1997[/TD]
[TD] $ 7.00[/TD]
[TD] $ 6.69[/TD]
[TD]-4.46%[/TD]
[/TR]
[TR]
[TD]VSH[/TD]
[TD]1/2/1997[/TD]
[TD] $ 11.13[/TD]
[TD] $ 10.64[/TD]
[TD]-4.40%[/TD]
[/TR]
[TR]
[TD]CTR[/TD]
[TD]1/2/1997[/TD]
[TD] $ 3.50[/TD]
[TD] $ 3.35[/TD]
[TD]-4.40%[/TD]
[/TR]
[TR]
[TD]KSS[/TD]
[TD]1/2/1997[/TD]
[TD] $ 9.84[/TD]
[TD] $ 9.41[/TD]
[TD]-4.37%[/TD]
[/TR]
[TR]
[TD]RE[/TD]
[TD]1/2/1997[/TD]
[TD] $ 28.62[/TD]
[TD] $ 27.37[/TD]
[TD]-4.37%[/TD]
[/TR]
[TR]
[TD]DYN[/TD]
[TD]1/2/1997[/TD]
[TD] $ 83.75[/TD]
[TD] $ 80.15[/TD]
[TD]-4.30%[/TD]
[/TR]
[TR]
[TD]CHH[/TD]
[TD]1/2/1997[/TD]
[TD] $ 7.46[/TD]
[TD] $ 7.14[/TD]
[TD]-4.23%[/TD]
[/TR]
[TR]
[TD]EV[/TD]
[TD]1/2/1997[/TD]
[TD] $ 2.97[/TD]
[TD] $ 2.84[/TD]
[TD]-4.21%[/TD]
[/TR]
[TR]
[TD]TIF[/TD]
[TD]1/2/1997[/TD]
[TD] $ 9.22[/TD]
[TD] $ 8.84[/TD]
[TD]-4.12%[/TD]
[/TR]
[TR]
[TD]AN[/TD]
[TD]1/2/1997[/TD]
[TD] $ 28.23[/TD]
[TD] $ 27.08[/TD]
[TD]-4.07%[/TD]
[/TR]
[TR]
[TD]DRI[/TD]
[TD]1/2/1997[/TD]
[TD] $ 5.91[/TD]
[TD] $ 5.67[/TD]
[TD]-4.06%[/TD]
[/TR]
[TR]
[TD]ATI[/TD]
[TD]1/2/1997[/TD]
[TD] $ 38.50[/TD]
[TD] $ 36.95[/TD]
[TD]-4.03%[/TD]
[/TR]
[TR]
[TD]HOV[/TD]
[TD]1/2/1997[/TD]
[TD] $ 3.78[/TD]
[TD] $ 3.63[/TD]
[TD]-3.97%[/TD]
[/TR]
[TR]
[TD]AZO[/TD]
[TD]1/3/1997[/TD]
[TD] $ 25.75[/TD]
[TD] $ 24.00[/TD]
[TD]-6.80%[/TD]
[/TR]
[TR]
[TD]AED[/TD]
[TD]1/3/1997[/TD]
[TD] $ 31.50[/TD]
[TD] $ 29.50[/TD]
[TD]-6.35%[/TD]
[/TR]
[TR]
[TD]NCI[/TD]
[TD]1/3/1997[/TD]
[TD] $ 21.67[/TD]
[TD] $ 20.33[/TD]
[TD]-6.18%[/TD]
[/TR]
[TR]
[TD]ABM[/TD]
[TD]1/3/1997[/TD]
[TD] $ 9.63[/TD]
[TD] $ 9.13[/TD]
[TD]-5.19%[/TD]
[/TR]
[TR]
[TD]SCL[/TD]
[TD]1/3/1997[/TD]
[TD] $ 10.19[/TD]
[TD] $ 9.75[/TD]
[TD]-4.27%[/TD]
[/TR]
[TR]
[TD]LH[/TD]
[TD]1/3/1997[/TD]
[TD] $ 6.33[/TD]
[TD] $ 6.06[/TD]
[TD]-4.27%[/TD]
[/TR]
[TR]
[TD]DNR[/TD]
[TD]1/3/1997[/TD]
[TD] $ 3.66[/TD]
[TD] $ 3.50[/TD]
[TD]-4.24%[/TD]
[/TR]
[TR]
[TD]ATI[/TD]
[TD]1/3/1997[/TD]
[TD] $ 38.50[/TD]
[TD] $ 36.95[/TD]
[TD]-4.03%[/TD]
[/TR]
[TR]
[TD]HHS[/TD]
[TD]1/3/1997[/TD]
[TD] $ 9.04[/TD]
[TD] $ 8.71[/TD]
[TD]-3.65%[/TD]
[/TR]
[TR]
[TD]SID[/TD]
[TD]1/3/1997[/TD]
[TD] $ 0.79[/TD]
[TD] $ 0.76[/TD]
[TD]-3.62%[/TD]
[/TR]
[TR]
[TD]MRO[/TD]
[TD]1/3/1997[/TD]
[TD] $ 12.38[/TD]
[TD] $ 11.94[/TD]
[TD]-3.56%[/TD]
[/TR]
[TR]
[TD]FFG[/TD]
[TD]1/3/1997[/TD]
[TD] $ 12.44[/TD]
[TD] $ 12.00[/TD]
[TD]-3.54%[/TD]
[/TR]
[TR]
[TD]UIS[/TD]
[TD]1/3/1997[/TD]
[TD] $ 72.50[/TD]
[TD] $ 70.00[/TD]
[TD]-3.45%[/TD]
[/TR]
[TR]
[TD]GES[/TD]
[TD]1/3/1997[/TD]
[TD] $ 7.38[/TD]
[TD] $ 7.13[/TD]
[TD]-3.39%[/TD]
[/TR]
[TR]
[TD]CRT[/TD]
[TD]1/3/1997[/TD]
[TD] $ 15.25[/TD]
[TD] $ 14.75[/TD]
[TD]-3.28%[/TD]
[/TR]
[TR]
[TD]TTI[/TD]
[TD]1/3/1997[/TD]
[TD] $ 5.92[/TD]
[TD] $ 5.73[/TD]
[TD]-3.28%[/TD]
[/TR]
[TR]
[TD]MTH[/TD]
[TD]1/3/1997[/TD]
[TD] $ 1.88[/TD]
[TD] $ 1.82[/TD]
[TD]-3.19%[/TD]
[/TR]
[TR]
[TD]SGY[/TD]
[TD]1/3/1997[/TD]
[TD] $ 1,140.00[/TD]
[TD] $ 1,104.80[/TD]
[TD]-3.09%[/TD]
[/TR]
[TR]
[TD]HVT[/TD]
[TD]1/3/1997[/TD]
[TD] $ 5.87[/TD]
[TD] $ 5.69[/TD]
[TD]-3.07%[/TD]
[/TR]
[TR]
[TD]CIA[/TD]
[TD]1/3/1997[/TD]
[TD] $ 5.64[/TD]
[TD] $ 5.47[/TD]
[TD]-3.01%[/TD]
[/TR]
[TR]
[TD]CGI[/TD]
[TD]1/3/1997[/TD]
[TD] $ 6.28[/TD]
[TD] $ 6.09[/TD]
[TD]-2.98%[/TD]
[/TR]
[TR]
[TD]PIR[/TD]
[TD]1/3/1997[/TD]
[TD] $ 7.78[/TD]
[TD] $ 7.55[/TD]
[TD]-2.96%[/TD]
[/TR]
[TR]
[TD]SPG[/TD]
[TD]1/3/1997[/TD]
[TD] $ 30.62[/TD]
[TD] $ 29.75[/TD]
[TD]-2.84%[/TD]
[/TR]
[TR]
[TD]IVC[/TD]
[TD]1/3/1997[/TD]
[TD] $ 26.50[/TD]
[TD] $ 25.75[/TD]
[TD]-2.83%[/TD]
[/TR]
[TR]
[TD]WM[/TD]
[TD]1/3/1997[/TD]
[TD] $ 30.97[/TD]
[TD] $ 30.10[/TD]
[TD]-2.81%[/TD]
[/TR]
[TR]
[TD]AIV[/TD]
[TD]1/3/1997[/TD]
[TD] $ 26.87[/TD]
[TD] $ 26.12[/TD]
[TD]-2.79%[/TD]
[/TR]
[TR]
[TD]NWN[/TD]
[TD]1/3/1997[/TD]
[TD] $ 24.50[/TD]
[TD] $ 23.87[/TD]
[TD]-2.57%[/TD]
[/TR]
[TR]
[TD]TG[/TD]
[TD]1/3/1997[/TD]
[TD] $ 13.59[/TD]
[TD] $ 13.25[/TD]
[TD]-2.50%[/TD]
[/TR]
[TR]
[TD]FNF[/TD]
[TD]1/3/1997[/TD]
[TD] $ 3.82[/TD]
[TD] $ 3.72[/TD]
[TD]-2.49%[/TD]
[/TR]
[TR]
[TD]CACI[/TD]
[TD]1/3/1997[/TD]
[TD] $ 10.38[/TD]
[TD] $ 10.13[/TD]
[TD]-2.41%[/TD]
[/TR]
[TR]
[TD]ANF[/TD]
[TD]1/6/1997[/TD]
[TD] $ 8.06[/TD]
[TD] $ 6.75[/TD]
[TD]-16.25%[/TD]
[/TR]
[TR]
[TD]AZO[/TD]
[TD]1/6/1997[/TD]
[TD] $ 21.75[/TD]
[TD] $ 20.12[/TD]
[TD]-7.49%[/TD]
[/TR]
[TR]
[TD]KGC[/TD]
[TD]1/6/1997[/TD]
[TD] $ 21.00[/TD]
[TD] $ 19.50[/TD]
[TD]-7.14%[/TD]
[/TR]
[TR]
[TD]SHW[/TD]
[TD]1/6/1997[/TD]
[TD] $ 28.00[/TD]
[TD] $ 26.00[/TD]
[TD]-7.14%[/TD]
[/TR]
[TR]
[TD]CEN[/TD]
[TD]1/6/1997[/TD]
[TD] $ 19.75[/TD]
[TD] $ 18.38[/TD]
[TD]-6.96%[/TD]
[/TR]
[TR]
[TD]AGM.A[/TD]
[TD]1/6/1997[/TD]
[TD] $ 28.75[/TD]
[TD] $ 26.75[/TD]
[TD]-6.96%[/TD]
[/TR]
[TR]
[TD]TYL[/TD]
[TD]1/6/1997[/TD]
[TD] $ 2.00[/TD]
[TD] $ 1.87[/TD]
[TD]-6.50%[/TD]
[/TR]
[TR]
[TD]WSM[/TD]
[TD]1/6/1997[/TD]
[TD] $ 9.00[/TD]
[TD] $ 8.47[/TD]
[TD]-5.89%[/TD]
[/TR]
[TR]
[TD]SYY[/TD]
[TD]1/6/1997[/TD]
[TD] $ 8.19[/TD]
[TD] $ 7.72[/TD]
[TD]-5.74%[/TD]
[/TR]
[TR]
[TD]LOW[/TD]
[TD]1/6/1997[/TD]
[TD] $ 4.36[/TD]
[TD] $ 4.11[/TD]
[TD]-5.73%[/TD]
[/TR]
[TR]
[TD]ELY[/TD]
[TD]1/6/1997[/TD]
[TD] $ 30.75[/TD]
[TD] $ 29.12[/TD]
[TD]-5.30%[/TD]
[/TR]
[TR]
[TD]JOF[/TD]
[TD]1/6/1997[/TD]
[TD] $ 7.12[/TD]
[TD] $ 6.75[/TD]
[TD]-5.20%[/TD]
[/TR]
[TR]
[TD]GPS[/TD]
[TD]1/6/1997[/TD]
[TD] $ 9.11[/TD]
[TD] $ 8.67[/TD]
[TD]-4.83%[/TD]
[/TR]
[TR]
[TD]JEC[/TD]
[TD]1/6/1997[/TD]
[TD] $ 6.63[/TD]
[TD] $ 6.32[/TD]
[TD]-4.68%[/TD]
[/TR]
[TR]
[TD]NEM[/TD]
[TD]1/6/1997[/TD]
[TD] $ 43.25[/TD]
[TD] $ 41.25[/TD]
[TD]-4.62%[/TD]
[/TR]
[TR]
[TD]EVG[/TD]
[TD]1/6/1997[/TD]
[TD] $ 4.13[/TD]
[TD] $ 3.94[/TD]
[TD]-4.60%[/TD]
[/TR]
[TR]
[TD]BYD[/TD]
[TD]1/6/1997[/TD]
[TD] $ 8.50[/TD]
[TD] $ 8.12[/TD]
[TD]-4.47%[/TD]
[/TR]
[TR]
[TD]HNP[/TD]
[TD]1/6/1997[/TD]
[TD] $ 11.25[/TD]
[TD] $ 10.75[/TD]
[TD]-4.44%[/TD]
[/TR]
[TR]
[TD]CTX[/TD]
[TD]1/6/1997[/TD]
[TD] $ 8.61[/TD]
[TD] $ 8.24[/TD]
[TD]-4.30%[/TD]
[/TR]
[TR]
[TD]LH[/TD]
[TD]1/6/1997[/TD]
[TD] $ 6.33[/TD]
[TD] $ 6.06[/TD]
[TD]-4.27%[/TD]
[/TR]
[TR]
[TD]EGN[/TD]
[TD]1/6/1997[/TD]
[TD] $ 7.60[/TD]
[TD] $ 7.28[/TD]
[TD]-4.21%[/TD]
[/TR]
[TR]
[TD]ATI[/TD]
[TD]1/6/1997[/TD]
[TD] $ 38.50[/TD]
[TD] $ 36.95[/TD]
[TD]-4.03%[/TD]
[/TR]
[TR]
[TD]TGT[/TD]
[TD]1/6/1997[/TD]
[TD] $ 9.53[/TD]
[TD] $ 9.16[/TD]
[TD]-3.88%[/TD]
[/TR]
[TR]
[TD]TIF[/TD]
[TD]1/6/1997[/TD]
[TD] $ 8.87[/TD]
[TD] $ 8.53[/TD]
[TD]-3.83%[/TD]
[/TR]
[TR]
[TD]DEL[/TD]
[TD]1/6/1997[/TD]
[TD] $ 23.25[/TD]
[TD] $ 22.37[/TD]
[TD]-3.78%[/TD]
[/TR]
[TR]
[TD]TRK[/TD]
[TD]1/6/1997[/TD]
[TD] $ 20.37[/TD]
[TD] $ 19.62[/TD]
[TD]-3.68%[/TD]
[/TR]
[TR]
[TD]PIR[/TD]
[TD]1/6/1997[/TD]
[TD] $ 7.55[/TD]
[TD] $ 7.28[/TD]
[TD]-3.58%[/TD]
[/TR]
[TR]
[TD]GES[/TD]
[TD]1/6/1997[/TD]
[TD] $ 7.13[/TD]
[TD] $ 6.88[/TD]
[TD]-3.51%[/TD]
[/TR]
[TR]
[TD]SAM[/TD]
[TD]1/6/1997[/TD]
[TD] $ 10.88[/TD]
[TD] $ 10.50[/TD]
[TD]-3.49%[/TD]
[/TR]
[TR]
[TD]CCL[/TD]
[TD]1/6/1997[/TD]
[TD] $ 16.37[/TD]
[TD] $ 15.81[/TD]
[TD]-3.42%[/TD]
[/TR]
[TR]
[TD]LH[/TD]
[TD]1/7/1997[/TD]
[TD] $ 6.33[/TD]
[TD] $ 5.55[/TD]
[TD]-12.32%[/TD]
[/TR]
[TR]
[TD]NMR[/TD]
[TD]1/7/1997[/TD]
[TD] $ 15.05[/TD]
[TD] $ 13.60[/TD]
[TD]-9.63%[/TD]
[/TR]
[TR]
[TD]TYL[/TD]
[TD]1/7/1997[/TD]
[TD] $ 2.00[/TD]
[TD] $ 1.87[/TD]
[TD]-6.50%[/TD]
[/TR]
[TR]
[TD]FCN[/TD]
[TD]1/7/1997[/TD]
[TD] $ 4.27[/TD]
[TD] $ 4.05[/TD]
[TD]-5.15%[/TD]
[/TR]
[TR]
[TD]CYD[/TD]
[TD]1/7/1997[/TD]
[TD] $ 5.12[/TD]
[TD] $ 4.87[/TD]
[TD]-4.88%[/TD]
[/TR]
[TR]
[TD]FCF[/TD]
[TD]1/7/1997[/TD]
[TD] $ 9.19[/TD]
[TD] $ 8.75[/TD]
[TD]-4.79%[/TD]
[/TR]
[TR]
[TD]VGR[/TD]
[TD]1/7/1997[/TD]
[TD] $ 3.87[/TD]
[TD] $ 3.69[/TD]
[TD]-4.65%[/TD]
[/TR]
[TR]
[TD]TEVA[/TD]
[TD]1/7/1997[/TD]
[TD] $ 6.95[/TD]
[TD] $ 6.64[/TD]
[TD]-4.49%[/TD]
[/TR]
[TR]
[TD]BRC[/TD]
[TD]1/7/1997[/TD]
[TD] $ 12.19[/TD]
[TD] $ 11.66[/TD]
[TD]-4.35%[/TD]
[/TR]
[TR]
[TD]SMP[/TD]
[TD]1/7/1997[/TD]
[TD] $ 14.62[/TD]
[TD] $ 14.00[/TD]
[TD]-4.24%[/TD]
[/TR]
[TR]
[TD]TKF[/TD]
[TD]1/7/1997[/TD]
[TD] $ 3.59[/TD]
[TD] $ 3.44[/TD]
[TD]-4.18%[/TD]
[/TR]
[TR]
[TD]ATI[/TD]
[TD]1/7/1997[/TD]
[TD] $ 38.50[/TD]
[TD] $ 36.95[/TD]
[TD]-4.03%[/TD]
[/TR]
[TR]
[TD]RT[/TD]
[TD]1/7/1997[/TD]
[TD] $ 4.72[/TD]
[TD] $ 4.53[/TD]
[TD]-4.03%[/TD]
[/TR]
[TR]
[TD]TNH[/TD]
[TD]1/7/1997[/TD]
[TD] $ 43.25[/TD]
[TD] $ 41.63[/TD]
[TD]-3.76%[/TD]
[/TR]
[TR]
[TD]ANF[/TD]
[TD]1/7/1997[/TD]
[TD] $ 6.75[/TD]
[TD] $ 6.50[/TD]
[TD]-3.70%[/TD]
[/TR]
[TR]
[TD]AXE[/TD]
[TD]1/7/1997[/TD]
[TD] $ 17.37[/TD]
[TD] $ 16.75[/TD]
[TD]-3.57%[/TD]
[/TR]
[TR]
[TD]CRS[/TD]
[TD]1/7/1997[/TD]
[TD] $ 18.06[/TD]
[TD] $ 17.44[/TD]
[TD]-3.46%[/TD]
[/TR]
[TR]
[TD]AP[/TD]
[TD]1/7/1997[/TD]
[TD] $ 11.50[/TD]
[TD] $ 11.12[/TD]
[TD]-3.30%[/TD]
[/TR]
[TR]
[TD]EBF[/TD]
[TD]1/7/1997[/TD]
[TD] $ 11.50[/TD]
[TD] $ 11.12[/TD]
[TD]-3.30%[/TD]
[/TR]
[TR]
[TD]RE[/TD]
[TD]1/7/1997[/TD]
[TD] $ 27.75[/TD]
[TD] $ 26.87[/TD]
[TD]-3.17%[/TD]
[/TR]
[TR]
[TD]WSO[/TD]
[TD]1/7/1997[/TD]
[TD] $ 19.00[/TD]
[TD] $ 18.41[/TD]
[TD]-3.11%[/TD]
[/TR]
[TR]
[TD]IMAX[/TD]
[TD]1/7/1997[/TD]
[TD] $ 16.25[/TD]
[TD] $ 15.75[/TD]
[TD]-3.08%[/TD]
[/TR]
[TR]
[TD]MYE[/TD]
[TD]1/7/1997[/TD]
[TD] $ 7.95[/TD]
[TD] $ 7.71[/TD]
[TD]-3.02%[/TD]
[/TR]
[TR]
[TD]VVI[/TD]
[TD]1/7/1997[/TD]
[TD] $ 15.57[/TD]
[TD] $ 15.11[/TD]
[TD]-2.98%[/TD]
[/TR]
[TR]
[TD]PBT[/TD]
[TD]1/7/1997[/TD]
[TD] $ 4.50[/TD]
[TD] $ 4.37[/TD]
[TD]-2.89%[/TD]
[/TR]
[TR]
[TD]BRO[/TD]
[TD]1/7/1997[/TD]
[TD] $ 2.28[/TD]
[TD] $ 2.21[/TD]
[TD]-2.86%[/TD]
[/TR]
[TR]
[TD]NCR[/TD]
[TD]1/7/1997[/TD]
[TD] $ 18.00[/TD]
[TD] $ 17.50[/TD]
[TD]-2.78%[/TD]
[/TR]
[TR]
[TD]SYK[/TD]
[TD]1/7/1997[/TD]
[TD] $ 8.00[/TD]
[TD] $ 7.78[/TD]
[TD]-2.75%[/TD]
[/TR]
[TR]
[TD]TNC[/TD]
[TD]1/7/1997[/TD]
[TD] $ 6.91[/TD]
[TD] $ 6.72[/TD]
[TD]-2.71%[/TD]
[/TR]
[TR]
[TD]CRY[/TD]
[TD]1/7/1997[/TD]
[TD] $ 9.25[/TD]
[TD] $ 9.00[/TD]
[TD]-2.70%[/TD]
[/TR]
[TR]
[TD]TYL[/TD]
[TD]1/8/1997[/TD]
[TD] $ 1.87[/TD]
[TD] $ 1.62[/TD]
[TD]-13.37%[/TD]
[/TR]
[TR]
[TD]CTR[/TD]
[TD]1/8/1997[/TD]
[TD] $ 3.34[/TD]
[TD] $ 3.00[/TD]
[TD]-9.99%[/TD]
[/TR]
[TR]
[TD]STN[/TD]
[TD]1/8/1997[/TD]
[TD] $ 3.33[/TD]
[TD] $ 3.05[/TD]
[TD]-8.56%[/TD]
[/TR]
[TR]
[TD]BZH[/TD]
[TD]1/8/1997[/TD]
[TD] $ 30.20[/TD]
[TD] $ 28.35[/TD]
[TD]-6.13%[/TD]
[/TR]
[TR]
[TD]HEI[/TD]
[TD]1/8/1997[/TD]
[TD] $ 2.60[/TD]
[TD] $ 2.46[/TD]
[TD]-5.30%[/TD]
[/TR]
[TR]
[TD]COT[/TD]
[TD]1/8/1997[/TD]
[TD] $ 7.44[/TD]
[TD] $ 7.06[/TD]
[TD]-5.11%[/TD]
[/TR]
[TR]
[TD]DECK[/TD]
[TD]1/8/1997[/TD]
[TD] $ 2.46[/TD]
[TD] $ 2.33[/TD]
[TD]-5.08%[/TD]
[/TR]
[TR]
[TD]RRC[/TD]
[TD]1/8/1997[/TD]
[TD] $ 14.51[/TD]
[TD] $ 13.84[/TD]
[TD]-4.60%[/TD]
[/TR]
[TR]
[TD]TGT[/TD]
[TD]1/8/1997[/TD]
[TD] $ 9.50[/TD]
[TD] $ 9.09[/TD]
[TD]-4.32%[/TD]
[/TR]
[TR]
[TD]BDC[/TD]
[TD]1/8/1997[/TD]
[TD] $ 27.12[/TD]
[TD] $ 26.00[/TD]
[TD]-4.13%[/TD]
[/TR]
[TR]
[TD]ATI[/TD]
[TD]1/8/1997[/TD]
[TD] $ 38.50[/TD]
[TD] $ 36.95[/TD]
[TD]-4.03%[/TD]
[/TR]
[TR]
[TD]EAT[/TD]
[TD]1/8/1997[/TD]
[TD] $ 7.23[/TD]
[TD] $ 6.94[/TD]
[TD]-3.97%[/TD]
[/TR]
[TR]
[TD]STZ[/TD]
[TD]1/8/1997[/TD]
[TD] $ 3.58[/TD]
[TD] $ 3.44[/TD]
[TD]-3.91%[/TD]
[/TR]
[TR]
[TD]USG[/TD]
[TD]1/8/1997[/TD]
[TD] $ 38.75[/TD]
[TD] $ 37.25[/TD]
[TD]-3.87%[/TD]
[/TR]
[TR]
[TD]AED[/TD]
[TD]1/8/1997[/TD]
[TD] $ 29.63[/TD]
[TD] $ 28.50[/TD]
[TD]-3.81%[/TD]
[/TR]
[TR]
[TD]MSM[/TD]
[TD]1/8/1997[/TD]
[TD] $ 18.19[/TD]
[TD] $ 17.50[/TD]
[TD]-3.79%[/TD]
[/TR]
[TR]
[TD]JOF[/TD]
[TD]1/8/1997[/TD]
[TD] $ 6.75[/TD]
[TD] $ 6.50[/TD]
[TD]-3.70%[/TD]
[/TR]
[TR]
[TD]LMT[/TD]
[TD]1/8/1997[/TD]
[TD] $ 46.25[/TD]
[TD] $ 44.56[/TD]
[TD]-3.65%[/TD]
[/TR]
[TR]
[TD]CRY[/TD]
[TD]1/8/1997[/TD]
[TD] $ 9.34[/TD]
[TD] $ 9.00[/TD]
[TD]-3.64%[/TD]
[/TR]
[TR]
[TD]SOR[/TD]
[TD]1/8/1997[/TD]
[TD] $ 42.17[/TD]
[TD] $ 40.66[/TD]
[TD]-3.58%[/TD]
[/TR]
[TR]
[TD]SAM[/TD]
[TD]1/8/1997[/TD]
[TD] $ 10.63[/TD]
[TD] $ 10.25[/TD]
[TD]-3.57%[/TD]
[/TR]
[TR]
[TD]STE[/TD]
[TD]1/8/1997[/TD]
[TD] $ 21.00[/TD]
[TD] $ 20.25[/TD]
[TD]-3.57%[/TD]
[/TR]
[TR]
[TD]RDC[/TD]
[TD]1/8/1997[/TD]
[TD] $ 25.25[/TD]
[TD] $ 24.37[/TD]
[TD]-3.49%[/TD]
[/TR]
[TR]
[TD]CDE[/TD]
[TD]1/8/1997[/TD]
[TD] $ 143.70[/TD]
[TD] $ 138.70[/TD]
[TD]-3.48%[/TD]
[/TR]
[TR]
[TD]MCK[/TD]
[TD]1/8/1997[/TD]
[TD] $ 26.19[/TD]
[TD] $ 25.28[/TD]
[TD]-3.47%[/TD]
[/TR]
[TR]
[TD]RS[/TD]
[TD]1/8/1997[/TD]
[TD] $ 7.63[/TD]
[TD] $ 7.37[/TD]
[TD]-3.47%[/TD]
[/TR]
[TR]
[TD]HNP[/TD]
[TD]1/8/1997[/TD]
[TD] $ 10.75[/TD]
[TD] $ 10.38[/TD]
[TD]-3.44%[/TD]
[/TR]
[TR]
[TD]CEL[/TD]
[TD]1/8/1997[/TD]
[TD] $ 73.75[/TD]
[TD] $ 71.25[/TD]
[TD]-3.39%[/TD]
[/TR]
[TR]
[TD]HMY[/TD]
[TD]1/8/1997[/TD]
[TD] $ 7.75[/TD]
[TD] $ 7.50[/TD]
[TD]-3.23%[/TD]
[/TR]
[TR]
[TD]HCC[/TD]
[TD]1/8/1997[/TD]
[TD] $ 18.33[/TD]
[TD] $ 17.75[/TD]
[TD]-3.16%[/TD]
[/TR]
</tbody>[/TABLE]

 

[My Aswer Is This]

I have been monitoring this thread.

So if I understand each day may have a number of rows that is not always consistent. I believe you said More then 30.

If there was a consistent number we could delete rows 30 to 60 then 90 to 120 etc. but in your case I do not believe we can do that. Is that correct?

 

[hiker95]

I don't currently have permission to attach a workbook.

northshoreroad,

Welcome to the MrExcel forum.

Can we see what your raw data workbook/worksheets look like, and, can we see what the results (manually formatted by you) should look like?

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[northshoreroad]

Thank you for the reply

You are correct. Each day will always have more than 30 rows but there is no consistency in the amount of rows over 30. Between 150 up to multiple thousands

So in the data I posted above 1/2/1997 had almost 1,000 rows 1/3/1997 had almost 900

 

[northshoreroad]

hiker95 - Thank you very much

I've uploaded my Excel sheet to Dropbox - https://www.dropbox.com/s/537eit6tdwzugc8/Data for Mr Excel.xlsx?dl=0

The first sheet has all the raw data. The second sheet has the first couple of days cleaned up with only the top 30

 

[My Aswer Is This]

I'm going to continue to monitor this thread. But your wanting to delete thousands and maybe even hundreds of thousand of rows and this is something I'm not able to do. Maybe Hiker or someone else here may have a answer for you.