VBA Help

N

njlevi49

Board Regular
Joined
Sep 20, 2009
Messages
51
I need help with VBA as this is my first time using it. I would like to copy and paste a1:ab14 to another worksheet but I need columns b, d, p, r removed also only rows with p in column A to paste with no blank rows showing, any help or ideas would be greatly appreciated.


[TABLE="width: 715"]
<colgroup><col style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;" width="25"> <col style="width: 12pt; mso-width-source: userset; mso-width-alt: 585;" width="16"> <col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <col style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;" width="92"> <col style="width: 26pt; mso-width-source: userset; mso-width-alt: 1243;" width="34"> <col style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;" span="10" width="26"> <col style="width: 17pt; mso-width-source: userset; mso-width-alt: 804;" width="22"> <col style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" width="49"> <col style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;" width="92"> <col style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;" width="26"> <col style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;" span="10" width="26"> <tbody>[TR]
[TD="class: xl68, width: 25, bgcolor: #DCE6F1"] [/TD]
[TD="class: xl68, width: 16, bgcolor: #DCE6F1"]A[/TD]
[TD="class: xl73, width: 61, bgcolor: #DCE6F1"]B[/TD]
[TD="class: xl68, width: 92, bgcolor: #DCE6F1"]C[/TD]
[TD="class: xl70, width: 34, bgcolor: #DCE6F1"]D[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]E[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]F[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]G[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]H[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]L[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]J[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]K[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]L[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]M[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]N[/TD]
[TD="class: xl68, width: 22, bgcolor: #DCE6F1"]O[/TD]
[TD="class: xl68, width: 49, bgcolor: #DCE6F1"]P[/TD]
[TD="class: xl68, width: 92, bgcolor: #DCE6F1"]Q[/TD]
[TD="class: xl70, width: 26, bgcolor: #DCE6F1"]R[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]S[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]T[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]U[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]V[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]W[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]X[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]Y[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]Z[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]AA[/TD]
[TD="class: xl68, width: 26, bgcolor: #DCE6F1"]AB[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]1[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]Gross[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl71, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]6[/TD]
[TD="class: xl69, bgcolor: transparent"]7[/TD]
[TD="class: xl69, bgcolor: transparent"]8[/TD]
[TD="class: xl69, bgcolor: transparent"]9[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]10[/TD]
[TD="class: xl69, bgcolor: transparent"]11[/TD]
[TD="class: xl69, bgcolor: transparent"]12[/TD]
[TD="class: xl69, bgcolor: transparent"]13[/TD]
[TD="class: xl69, bgcolor: transparent"]14[/TD]
[TD="class: xl69, bgcolor: transparent"]15[/TD]
[TD="class: xl69, bgcolor: transparent"]16[/TD]
[TD="class: xl69, bgcolor: transparent"]17[/TD]
[TD="class: xl69, bgcolor: transparent"]18[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]2[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Front Nine[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]7[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]6[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]8[/TD]
[TD="class: xl69, bgcolor: transparent"]9[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Back Nine[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]9[/TD]
[TD="class: xl69, bgcolor: transparent"]7[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]8[/TD]
[TD="class: xl69, bgcolor: transparent"]6[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]3[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Barker, Steve[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"]p[/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Barker, Steve[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]p[/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Batcheider, Jason[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Batcheider, Jason[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]5[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Budd, Jerry [/TD]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Budd, Jerry [/TD]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]6[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Campau, Chad[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Campau, Chad[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]7[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Coates, Brian[/TD]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]6[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]38[/TD]
[TD="class: xl69, bgcolor: transparent"]p[/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Coates, Brian[/TD]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]8[/TD]
[TD="class: xl69, bgcolor: transparent"]p[/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Conway, Casey[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Conway, Casey[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]9[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Curry, Claude[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Curry, Claude[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]10[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Dattilo, Mike[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Dattilo, Mike[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]11[/TD]
[TD="class: xl69, bgcolor: transparent"]p[/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Daugherty, Pat[/TD]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Daugherty, Pat[/TD]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]12[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Dennis, Brad[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Dennis, Brad[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]13[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Dougherty Jack[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Dougherty Jack[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #DCE6F1"]14[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"]<st1:date ls="trans" Month="04" Day="23" Year="13">04/23/13</st1:date> [/TD]
[TD="class: xl69, bgcolor: transparent"]Emeott,Mark [/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]36[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]41394[/TD]
[TD="class: xl69, bgcolor: transparent"]Emeott,Mark [/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl69, bgcolor: transparent"]37[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Hi

Try this:

Code: 
Sub CopyData()
Dim rData As Range
Dim wsNew As Worksheet

ActiveSheet.AutoFilterMode = False
Set rData = Range("A1:Ab14")
rData.AutoFilter field:=1, Criteria1:="p"
.AutoFilter.Range.Copy
Set wsNew = Sheets.Add
With wsNew
    .Range("A1").PasteSpecial
    .Range("b:b,d:d,p:p,r:r").Delete
End With


End Sub

Place it in a standard module and run it with the sheet containing your data active (ie visible on your Excel screen).
 
Upvote 0
Firefly2012 said:
Hi

Try this:

Code: 
Sub CopyData()
Dim rData As Range
Dim wsNew As Worksheet

ActiveSheet.AutoFilterMode = False
Set rData = Range("A1:Ab14")
rData.AutoFilter field:=1, Criteria1:="p"
.AutoFilter.Range.Copy
Set wsNew = Sheets.Add
With wsNew
    .Range("A1").PasteSpecial
    .Range("b:b,d:d,p:p,r:r").Delete
End With


End Sub

Place it in a standard module and run it with the sheet containing your data active (ie visible on your Excel screen).
Click to expand...

Sub CopyData()
Dim rData As Range
Dim wsNew As Worksheet
ActiveSheet.AutoFilterMode = False
Set rData = Range("a1:ab14")
rData.AutoFilter field:=1, Criteria1:="p"
.AutoFilter.Range.Copy (I get invalid or unqualified reference) with .AutoFilter highlighted
Set wsNew = Sheets.Add
With wsNew
.Range("A1").PasteSpecial
.Range("b:b,d:d,p:p,r:r").Delete
End With
End Sub

See above for the issue not sure how to fix it if I remove the period from .AutoFilter I get a run-time error 424
 
Upvote 0
Sub CopyData()
Dim rData As Range
Dim wsNew As Worksheet
ActiveSheet.AutoFilterMode = False
Set rData = Range("a1:ab14")
rData.AutoFilter field:=1, Criteria1:="p"
.AutoFilter.Range.Copy (I get invalid or unqualified reference) with .AutoFilter highlighted
Set wsNew = Sheets.Add
With wsNew
.Range("A1").PasteSpecial
.Range("b:b,d:d,p:p,r:r").Delete
End With
End Sub

See above for the issue not sure how to fix it if I remove the period from .AutoFilter I get a run-time error 424
 
Upvote 0
Apologies - I thought I had corrected that omission. The code should be:

Code: 
Sub CopyData()
Dim rData As Range
Dim wsNew As Worksheet

ActiveSheet.AutoFilterMode = False
Set rData = Range("A1:Ab14")
rData.AutoFilter field:=1, Criteria1:="p"
Activesheet.AutoFilter.Range.Copy
Set wsNew = Sheets.Add
With wsNew
    .Range("A1").PasteSpecial
    .Range("b:b,d:d,p:p,r:r").Delete
End With


End Sub
 
Upvote 0
Thanks that worked the only other problem with this is I just need the values not the formulas I am not sure how or where I would place the Pastespecial Operation Values. do you also know a book that would provide mw with different VBA samples for all occasions? Again Thank you
 
Upvote 0
Code: 
.Range("A1").PasteSpecial Paste:=xlPasteValues
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Return last date checked
Replies
3
Views
46
Peter_SSs
Peter_SSs
V
  • Question Question
Tracking individual codes by date and quantity
Replies
1
Views
30
Vorkosigan
V
D
  • Question Question
Locate first instance of all dates in a column and hide all remaining rows
Replies
4
Views
69
Peter_SSs
Peter_SSs
J
  • Solved
Daily 3yr CF: Need to flag 4th/last Thursday of each month
Replies
3
Views
195
Fluff
Fluff
H
  • Question Question
Transposing Data - Evaluating formula to an array error.
Replies
1
Views
38
Skyybot
Skyybot

Forum statistics

Threads
1,223,703
Messages
6,173,977
Members
452,540
Latest member
haasro02

Share this page

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
Back
Top