Looping thru rows and when a specific value is found in column 'N' sort all remaining rows in alpha order from column

simmonsv · Sep 16, 2013

I want to sort all remaining rows in alpha order on Vendor Name after P/U" value is found in column IncoT. There will ways be a value in column "Purch.Doc." I thought of coping entire sheet to another sheet delete rows where IncoT value is COL or P/U and then copy back but not sure that is the best solution. I have already sorted data by column IncoT. Any help on this would be greatly appreciated as always. Below is a sample of my sheet:[TABLE="width: 1047"]
<tbody>[TR]
[TD]CONF[/TD]
[TD]Purch.Doc.[/TD]
[TD]Item[/TD]
[TD]Buyer Name[/TD]
[TD]Vendor[/TD]
[TD]Vendor Name[/TD]
[TD]Plant[/TD]
[TD]Material[/TD]
[TD]Material description[/TD]
[TD]Due Date[/TD]
[TD]Due Qty[/TD]
[TD]Sched[/TD]
[TD]Priority[/TD]
[TD]IncoT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520791[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101135[/TD]
[TD]PACTIV CORP[/TD]
[TD]55[/TD]
[TD="align: right"]10058053[/TD]
[TD]MC5-0601 WHT 6COMP FIBER MOLDED TRAY[/TD]
[TD]09/12/13[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]COL[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521046[/TD]
[TD]10[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]200560[/TD]
[TD]ARCOT MANUFACTURING CORP[/TD]
[TD]55[/TD]
[TD="align: right"]923288[/TD]
[TD]9636W WHT 1GAL SOFT-N-SMOOTH HAND SOAP[/TD]
[TD]09/12/13[/TD]
[TD]36[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521046[/TD]
[TD]20[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]200560[/TD]
[TD]ARCOT MANUFACTURING CORP[/TD]
[TD]55[/TD]
[TD="align: right"]923287[/TD]
[TD]9560 NICE-N-CLEAN LAUNDRY DETERGENT[/TD]
[TD]09/12/13[/TD]
[TD]12[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521046[/TD]
[TD]30[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]200560[/TD]
[TD]ARCOT MANUFACTURING CORP[/TD]
[TD]55[/TD]
[TD="align: right"]10089247[/TD]
[TD]9709 REFRESH 1GAL QUAT SANITIZER[/TD]
[TD]09/12/13[/TD]
[TD]4[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521046[/TD]
[TD]40[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]200560[/TD]
[TD]ARCOT MANUFACTURING CORP[/TD]
[TD]55[/TD]
[TD="align: right"]10089248[/TD]
[TD]9584 FCC-84 1GAL DEGREASER / H/D CLNR[/TD]
[TD]09/12/13[/TD]
[TD]3[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520958[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]200144[/TD]
[TD]G & A PALLET COMPANY[/TD]
[TD]55[/TD]
[TD="align: right"]10098192[/TD]
[TD]44"X90"4 WAY PALLET[/TD]
[TD]09/11/13[/TD]
[TD]60[/TD]
[TD]T[/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521816[/TD]
[TD]10[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]100418[/TD]
[TD]GUARDIAN REPAIR & PARTS[/TD]
[TD]55[/TD]
[TD="align: right"]10015147[/TD]
[TD]5301ER MICRO FILTER F/WINDSOR SENSOR[/TD]
[TD]09/16/13[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520602[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]104690[/TD]
[TD]HBM SUPPLY OF TEXAS INC[/TD]
[TD]55[/TD]
[TD="align: right"]10089719[/TD]
[TD]253 POLYKEN 2"X60YD SLV DUCT TAPE[/TD]
[TD]09/12/13[/TD]
[TD]9[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520602[/TD]
[TD]20[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]104690[/TD]
[TD]HBM SUPPLY OF TEXAS INC[/TD]
[TD]55[/TD]
[TD="align: right"]10089770[/TD]
[TD]253 POLYKEN 1"X60YD SLV DUCT TAPE[/TD]
[TD]09/12/13[/TD]
[TD]3[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520411[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]104934[/TD]
[TD]MRI DPC INC[/TD]
[TD]55[/TD]
[TD="align: right"]197960[/TD]
[TD]H0369819 6"X90"X2"CORNER PROTECTOR[/TD]
[TD]09/13/13[/TD]
[TD]2,464.00[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521083[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101143[/TD]
[TD]NATIONAL PAPER & PLASTICS CO[/TD]
[TD]55[/TD]
[TD="align: right"]620708[/TD]
[TD]D626790 VERSICOPY 8-1/2"X11"20# WHT COPY[/TD]
[TD]09/16/13[/TD]
[TD]240[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520866[/TD]
[TD]10[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101293[/TD]
[TD]POWR-FLITE[/TD]
[TD]55[/TD]
[TD="align: right"]10066623[/TD]
[TD]PS35E SPOTTER MACHINE W/AA163 TOOL[/TD]
[TD]09/12/13[/TD]
[TD]1[/TD]
[TD]T[/TD]
[TD]P1[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500522011[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100326[/TD]
[TD]PRIMESOURCE INC[/TD]
[TD]55[/TD]
[TD="align: right"]102830[/TD]
[TD]GC410 10'X100' .004 CLR POLY FILM[/TD]
[TD]09/16/13[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519291[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]102632[/TD]
[TD]PRINT SOURCE INC[/TD]
[TD]55[/TD]
[TD="align: right"]191108[/TD]
[TD]1103 GIFT WRAP CLAIM CHECK[/TD]
[TD]09/13/13[/TD]
[TD]1,000.00[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500522017[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100571[/TD]
[TD]SCHERMERHORN BROS COMPANY[/TD]
[TD]55[/TD]
[TD="align: right"]10069529[/TD]
[TD]MAN1/4"1/4"X600' MANILLA ROPE[/TD]
[TD]09/16/13[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500516850[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]100502[/TD]
[TD]STERLING MFG & DIST[/TD]
[TD]55[/TD]
[TD="align: right"]10037276[/TD]
[TD]5"X4-1/2"POLY FOAM CAP[/TD]
[TD]09/04/13[/TD]
[TD]1,000.00[/TD]
[TD]T[/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521096[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]100502[/TD]
[TD]STERLING MFG & DIST[/TD]
[TD]55[/TD]
[TD="align: right"]10102414[/TD]
[TD]10-1/2X18X20 1.7WHT PE FOAM ENDCAP SET[/TD]
[TD]09/11/13[/TD]
[TD]5[/TD]
[TD]T[/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520130[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]100502[/TD]
[TD]STERLING MFG & DIST[/TD]
[TD]55[/TD]
[TD="align: right"]10070554[/TD]
[TD]OPTIDISK FOAM G70 CHAR PU D/C ASSY W/TOP[/TD]
[TD]09/13/13[/TD]
[TD]1,000.00[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521987[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100379[/TD]
[TD]TEXAS TECHNOLOGIES[/TD]
[TD]55[/TD]
[TD="align: right"]10045628[/TD]
[TD]DESICCANT 2-UNIT KRAFT[/TD]
[TD]09/16/13[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521239[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]102751[/TD]
[TD]THE LABEL SMITH[/TD]
[TD]55[/TD]
[TD="align: right"]10080252[/TD]
[TD]1-1/2"CLR CIRCLE LABEL[/TD]
[TD]09/16/13[/TD]
[TD]1,200.00[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521577[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10084684[/TD]
[TD]UNV07071 PERMANENT MARKER PEN STLYE[/TD]
[TD]09/12/13[/TD]
[TD]12[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521577[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10084660[/TD]
[TD]IVR52448 BLK RUBBER MOUSE PAD[/TD]
[TD]09/12/13[/TD]
[TD]2[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521577[/TD]
[TD]30[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10089636[/TD]
[TD]UNV08850 POCKET HIGHLIGHTERS FLUOR COLOR[/TD]
[TD]09/12/13[/TD]
[TD]2[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521577[/TD]
[TD]40[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10084669[/TD]
[TD]QUA37890 9X12 28# KRAFT CLASP ENVELOPE[/TD]
[TD]09/12/13[/TD]
[TD]5[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521577[/TD]
[TD]50[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10086166[/TD]
[TD]GEM85T 2"STEEL T-PIN[/TD]
[TD]09/12/13[/TD]
[TD]5[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521577[/TD]
[TD]60[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10092246[/TD]
[TD]EPS-ERC38BR RED/BLK RIBBON F/EPSON M188B[/TD]
[TD]09/12/13[/TD]
[TD]10[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521654[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10056549[/TD]
[TD]MONARCH 1-LINE 8-BAND LABEL GUN[/TD]
[TD]09/11/13[/TD]
[TD]42[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521809[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10087929[/TD]
[TD]MNK925403 INK ROLLER[/TD]
[TD]09/12/13[/TD]
[TD]126[/TD]
[TD]T[/TD]
[TD]P1[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521809[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10089636[/TD]
[TD]UNV08850 POCKET HIGHLIGHTERS FLUOR COLOR[/TD]
[TD]09/12/13[/TD]
[TD]3[/TD]
[TD]T[/TD]
[TD]P1[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520596[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10084693[/TD]
[TD]UNV43614 48X36 NAT CORK BULLETIN BOARD[/TD]
[TD]09/05/13[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520596[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]101506[/TD]
[TD]UNITED STATIONERS SUPPLY CO[/TD]
[TD]55[/TD]
[TD="align: right"]10104283[/TD]
[TD]BVCSB1420001233 48"X72"CORK BOARD[/TD]
[TD]09/12/13[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521000[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]103365[/TD]
[TD]WAL-MART[/TD]
[TD]55[/TD]
[TD="align: right"]10093969[/TD]
[TD]OUTLET PLUG COVER[/TD]
[TD]09/17/13[/TD]
[TD]40[/TD]
[TD]T[/TD]
[TD]P3[/TD]
[TD]P/U[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521533[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104069[/TD]
[TD]AVERY DENNISON[/TD]
[TD]65[/TD]
[TD="align: right"]10087660[/TD]
[TD]FG-122 (000239) 1-LINE WHT LABEL F/1131[/TD]
[TD]09/13/13[/TD]
[TD]320[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521533[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104069[/TD]
[TD]AVERY DENNISON[/TD]
[TD]65[/TD]
[TD="align: right"]10069318[/TD]
[TD]FG-151 .44"X.78"FLOUR GRN LABEL[/TD]
[TD]09/13/13[/TD]
[TD]192[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521534[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104069[/TD]
[TD]AVERY DENNISON[/TD]
[TD]55[/TD]
[TD="align: right"]10087660[/TD]
[TD]FG-122 (000239) 1-LINE WHT LABEL F/1131[/TD]
[TD]09/16/13[/TD]
[TD]384[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521534[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104069[/TD]
[TD]AVERY DENNISON[/TD]
[TD]55[/TD]
[TD="align: right"]10069318[/TD]
[TD]FG-151 .44"X.78"FLOUR GRN LABEL[/TD]
[TD]09/16/13[/TD]
[TD]256[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521109[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104759[/TD]
[TD]BASS SECURITY SERVICES INC[/TD]
[TD]49[/TD]
[TD="align: right"]10092108[/TD]
[TD]1-3/4"X3/8"PLAIN WHT DEACTIVATABLE LABEL[/TD]
[TD]09/17/13[/TD]
[TD]184[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521110[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104759[/TD]
[TD]BASS SECURITY SERVICES INC[/TD]
[TD]55[/TD]
[TD="align: right"]10092108[/TD]
[TD]1-3/4"X3/8"PLAIN WHT DEACTIVATABLE LABEL[/TD]
[TD]09/17/13[/TD]
[TD]230[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521242[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104759[/TD]
[TD]BASS SECURITY SERVICES INC[/TD]
[TD]55[/TD]
[TD="align: right"]10092108[/TD]
[TD]1-3/4"X3/8"PLAIN WHT DEACTIVATABLE LABEL[/TD]
[TD]09/17/13[/TD]
[TD]2,990.00[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521244[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104759[/TD]
[TD]BASS SECURITY SERVICES INC[/TD]
[TD]65[/TD]
[TD="align: right"]10092108[/TD]
[TD]1-3/4"X3/8"PLAIN WHT DEACTIVATABLE LABEL[/TD]
[TD]09/17/13[/TD]
[TD]1,610.00[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521685[/TD]
[TD]10[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]200717[/TD]
[TD]BOBRICK WASHROOM EQUIPMENT INC[/TD]
[TD]55[/TD]
[TD="align: right"]992809[/TD]
[TD]B270 CONTURA S/S SANITARY NAPKIN RECEPT[/TD]
[TD]09/17/13[/TD]
[TD]12[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520964[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]200341[/TD]
[TD]CONDUCTIVE CONTAINERS INC[/TD]
[TD]55[/TD]
[TD="align: right"]10076462[/TD]
[TD]12.5X10.5X2.5 CONDUCTIVE BOX W/ A/S FOAM[/TD]
[TD]09/13/13[/TD]
[TD]27[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520964[/TD]
[TD]20[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]200341[/TD]
[TD]CONDUCTIVE CONTAINERS INC[/TD]
[TD]55[/TD]
[TD="align: right"]10032518[/TD]
[TD]7X5X2-1/2 CONDUCTIVE BOX W/A/S FOAM[/TD]
[TD]09/13/13[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500518750[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101601[/TD]
[TD]KERRY INGREDIENTS AND FLAVOURS[/TD]
[TD]55[/TD]
[TD="align: right"]10083971[/TD]
[TD]720697.LB6 TFF MULTI-COLORED SPRINKLES[/TD]
[TD]09/13/13[/TD]
[TD]70[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500518750[/TD]
[TD]20[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101601[/TD]
[TD]KERRY INGREDIENTS AND FLAVOURS[/TD]
[TD]55[/TD]
[TD="align: right"]10083970[/TD]
[TD]Q11676.LB6 TFF CHOC SPRINKLES[/TD]
[TD]09/13/13[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500516722[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]102814[/TD]
[TD]LAGASSE BROTHERS INC[/TD]
[TD]55[/TD]
[TD="align: right"]10059901[/TD]
[TD]Q311 UPRIGHT SCRUBBER PAD HOLDER[/TD]
[TD]09/04/13[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519505[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100701[/TD]
[TD]PLAS-TIES[/TD]
[TD]55[/TD]
[TD="align: right"]191886[/TD]
[TD]P1140LT 11"NAT LADDER TIES[/TD]
[TD]09/04/13[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520882[/TD]
[TD]10[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]100485[/TD]
[TD]PRO TEAM INC[/TD]
[TD]55[/TD]
[TD="align: right"]10001764[/TD]
[TD]100331 COACH VAC VACUUM BAG 10QT[/TD]
[TD]09/11/13[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520882[/TD]
[TD]20[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]100485[/TD]
[TD]PRO TEAM INC[/TD]
[TD]55[/TD]
[TD="align: right"]10015783[/TD]
[TD]101678 50' YEL CORD W/CORD WRAP[/TD]
[TD]09/11/13[/TD]
[TD]11[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10101242[/TD]
[TD]2X2X2X288 .180/.180 REDDI CRATE[/TD]
[TD]09/16/13[/TD]
[TD]224[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]20[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10101243[/TD]
[TD]6X6X6X168 .200/.200 REDDI CRATE[/TD]
[TD]09/16/13[/TD]
[TD]120[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]30[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10101244[/TD]
[TD]3X3X3X288 .160/.160 QUICK CRATE[/TD]
[TD]09/16/13[/TD]
[TD]196[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]40[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10101246[/TD]
[TD]6X6X6X288 .200/.200 REDDI CRATE[/TD]
[TD]09/16/13[/TD]
[TD]180[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]50[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10101247[/TD]
[TD]8X8X8X288 .200/.200 REDDI CRATE[/TD]
[TD]09/16/13[/TD]
[TD]120[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]60[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10103991[/TD]
[TD]2X2X2X168 .180/.180 REDDI CRATE[/TD]
[TD]09/16/13[/TD]
[TD]112[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]70[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10103995[/TD]
[TD]4X4X4X168 .160/.160 QUICK CRATE[/TD]
[TD]09/16/13[/TD]
[TD]196[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]80[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10103997[/TD]
[TD]4X4X4X288 .160/.160 QUICK CRATE[/TD]
[TD]09/16/13[/TD]
[TD]196[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]90[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10103998[/TD]
[TD]8"X8"X8"X168" .200/.200 REDDI CRATE[/TD]
[TD]09/16/13[/TD]
[TD]80[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500519231[/TD]
[TD]100[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]100335[/TD]
[TD]REDDI-PAC INC[/TD]
[TD]55[/TD]
[TD="align: right"]10104001[/TD]
[TD]3"X3"X3"X168" .160/.160 QUICK CRATE[/TD]
[TD]09/16/13[/TD]
[TD]196[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521943[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]104901[/TD]
[TD]STEWARTS PACKAGING[/TD]
[TD]55[/TD]
[TD="align: right"]10035931[/TD]
[TD]15500299 1-1/2"X2"LABEL P/SAFE HANDLING[/TD]
[TD]09/13/13[/TD]
[TD]12[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521582[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101118[/TD]
[TD]TALO ENTERPRISES INC[/TD]
[TD]55[/TD]
[TD="align: right"]10039439[/TD]
[TD]SL339 3" PISTOL GRIP TAPE DISP[/TD]
[TD]09/17/13[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500517963[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]100134[/TD]
[TD]TULSACK-A DIV OS DENMAR PROD INC[/TD]
[TD]55[/TD]
[TD="align: right"]10032667[/TD]
[TD]16"GOLD VOGUE BAG P/ACCESSORY PLACE[/TD]
[TD]09/16/13[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500517963[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]100134[/TD]
[TD]TULSACK-A DIV OS DENMAR PROD INC[/TD]
[TD]55[/TD]
[TD="align: right"]10032668[/TD]
[TD]8"CUB KRAFT SHOP BAG P/ACCESSORY PLACE[/TD]
[TD]09/16/13[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500517963[/TD]
[TD]30[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]100134[/TD]
[TD]TULSACK-A DIV OS DENMAR PROD INC[/TD]
[TD]55[/TD]
[TD="align: right"]10032669[/TD]
[TD]16"GLD QUEEN BAG P/ACCESSORY PLACE[/TD]
[TD]09/16/13[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]10[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]628610[/TD]
[TD]3100 8753 20"AQUA BURNISH FLOOR PAD[/TD]
[TD]09/16/13[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]20[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]920161[/TD]
[TD]5L TNF QUAT DISF[/TD]
[TD]09/16/13[/TD]
[TD]12[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]30[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]920405[/TD]
[TD]4100N NIAGARA 20"WHT POLISH PAD[/TD]
[TD]09/16/13[/TD]
[TD]30[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]40[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]920406[/TD]
[TD]5100N NIAGARA 20"RED BUFFING PAD[/TD]
[TD]09/16/13[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]50[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]920408[/TD]
[TD]7200N NIAGARA 20"BLK STRIP PAD[/TD]
[TD]09/16/13[/TD]
[TD]17[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]60[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]962560[/TD]
[TD]3000 SCOTCHBRITE POWER SPONGE SCRUBBER[/TD]
[TD]09/16/13[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]70[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]10064256[/TD]
[TD]3500N 20"NIAGARA TAN HOG HAIR PAD[/TD]
[TD]09/16/13[/TD]
[TD]34[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]80[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]962688[/TD]
[TD]08004 8541 DOODLEBUG 4-5/8"BRN PAD[/TD]
[TD]09/16/13[/TD]
[TD]16[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]90[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]10032840[/TD]
[TD]7400N NIAGARA HIGH PERF 20"BLK PAD[/TD]
[TD]09/16/13[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]100[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]10083685[/TD]
[TD]59152 EASY TRAP 8"X6"DUSTER[/TD]
[TD]09/16/13[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]110[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]964338[/TD]
[TD]5300 8413 20"BLU FLOOR CLNR PAD[/TD]
[TD]09/16/13[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]120[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]964528[/TD]
[TD]18066 3200 20"TOPLINE SPEED BURNISH PAD[/TD]
[TD]09/16/13[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]130[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]969535[/TD]
[TD]05606 3400 20"TAN BURNISH PAD[/TD]
[TD]09/16/13[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]140[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]10062213[/TD]
[TD]SPP20 20"SURFACE PREP PAD[/TD]
[TD]09/16/13[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]150[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]10069223[/TD]
[TD]SPP14X28 28"X14"MAROON SURFACE PREP PAD[/TD]
[TD]09/16/13[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521044[/TD]
[TD]160[/TD]
[TD]Angela Starnes[/TD]
[TD="align: right"]101371[/TD]
[TD]3M-HOME AND COMMERCIAL CARE[/TD]
[TD]55[/TD]
[TD="align: right"]10098758[/TD]
[TD]RADIANCE 20"WHT POLISH PAD[/TD]
[TD]09/16/13[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500509915[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104640[/TD]
[TD]ANNJOY IMPORTS LLC[/TD]
[TD]65[/TD]
[TD="align: right"]10102449[/TD]
[TD]SM PINK&ORG PAPER BAG P/CC[/TD]
[TD]09/13/13[/TD]
[TD]662[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500509915[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104640[/TD]
[TD]ANNJOY IMPORTS LLC[/TD]
[TD]65[/TD]
[TD="align: right"]10102450[/TD]
[TD]MED PINK&ORG PAPER BAG P/CC[/TD]
[TD]09/13/13[/TD]
[TD]340[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500509915[/TD]
[TD]30[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104640[/TD]
[TD]ANNJOY IMPORTS LLC[/TD]
[TD]65[/TD]
[TD="align: right"]10102451[/TD]
[TD]LG PINK&ORG PAPER BAG P/CC[/TD]
[TD]09/13/13[/TD]
[TD]367[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520724[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]200280[/TD]
[TD]APOLLO DISTRIBUTORS[/TD]
[TD]55[/TD]
[TD="align: right"]798705[/TD]
[TD]#33 3-1/2X3-1/2X1 WHT JEWEL BOX W/COTTON[/TD]
[TD]09/16/13[/TD]
[TD]648[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520724[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]200280[/TD]
[TD]APOLLO DISTRIBUTORS[/TD]
[TD]55[/TD]
[TD="align: right"]709385[/TD]
[TD]95/53 5-1/4X3-3/4X7/8 JEWELRY BOX[/TD]
[TD]09/16/13[/TD]
[TD]392[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500517701[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]200317[/TD]
[TD]BROWN PAPER GOODS CO INC[/TD]
[TD]55[/TD]
[TD="align: right"]306602[/TD]
[TD]1306 FOIL BAG P/FRESH BAKED BREAD GARLIC[/TD]
[TD]09/13/13[/TD]
[TD]53[/TD]
[TD][/TD]
[TD]P1[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500514419[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104659[/TD]
[TD]CHARMING CHARLIE[/TD]
[TD]55[/TD]
[TD="align: right"]10103245[/TD]
[TD]PREPAID GOLD SHIMMER[/TD]
[TD]08/02/13[/TD]
[TD]432[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500514419[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104659[/TD]
[TD]CHARMING CHARLIE[/TD]
[TD]55[/TD]
[TD="align: right"]10103243[/TD]
[TD]PREPAID PINK SHIMMER[/TD]
[TD]08/02/13[/TD]
[TD]432[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500514419[/TD]
[TD]30[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104659[/TD]
[TD]CHARMING CHARLIE[/TD]
[TD]55[/TD]
[TD="align: right"]10103244[/TD]
[TD]PREPAID SILVER SHIMMER[/TD]
[TD]08/02/13[/TD]
[TD]432[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500514420[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104659[/TD]
[TD]CHARMING CHARLIE[/TD]
[TD]55[/TD]
[TD="align: right"]10103245[/TD]
[TD]PREPAID GOLD SHIMMER[/TD]
[TD]08/02/13[/TD]
[TD]432[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500514420[/TD]
[TD]20[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104659[/TD]
[TD]CHARMING CHARLIE[/TD]
[TD]55[/TD]
[TD="align: right"]10103243[/TD]
[TD]PREPAID PINK SHIMMER[/TD]
[TD]08/02/13[/TD]
[TD]432[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500514420[/TD]
[TD]30[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104659[/TD]
[TD]CHARMING CHARLIE[/TD]
[TD]55[/TD]
[TD="align: right"]10103244[/TD]
[TD]PREPAID SILVER SHIMMER[/TD]
[TD]08/02/13[/TD]
[TD]432[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520741[/TD]
[TD]10[/TD]
[TD]Annette McCleskey[/TD]
[TD="align: right"]104659[/TD]
[TD]CHARMING CHARLIE[/TD]
[TD]55[/TD]
[TD="align: right"]10102447[/TD]
[TD]PREPAID LUCKY/GLAMOUR SUBSCRIP BROCHURE[/TD]
[TD]09/10/13[/TD]
[TD]252[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500520214[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]104514[/TD]
[TD]CSM BAKERY PRODUCTS NA[/TD]
[TD]55[/TD]
[TD="align: right"]10081898[/TD]
[TD]ICING F/BASKIN ROBBINS ICE CREME CAKE[/TD]
[TD]09/17/13[/TD]
[TD]70[/TD]
[TD][/TD]
[TD]P3[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521595[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101382[/TD]
[TD]ELKAY PLASTICS[/TD]
[TD]55[/TD]
[TD="align: right"]10077408[/TD]
[TD]RL 101475 10"X14".75MIL ROLL POLY BAG[/TD]
[TD]09/12/13[/TD]
[TD]596[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521840[/TD]
[TD]10[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101382[/TD]
[TD]ELKAY PLASTICS[/TD]
[TD]55[/TD]
[TD="align: right"]121224[/TD]
[TD]F20608 6"X8".002 ZIPLOCK BAG[/TD]
[TD]09/13/13[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4500521840[/TD]
[TD]20[/TD]
[TD]Kathy Moody[/TD]
[TD="align: right"]101382[/TD]
[TD]ELKAY PLASTICS[/TD]
[TD]55[/TD]
[TD="align: right"]122587[/TD]
[TD]40F0912 9"X12".004 PLAIN POLY BAG[/TD]
[TD]09/13/13[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]P2[/TD]
[TD]PPD[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]

venkat1926 · Sep 17, 2013

where incot colmn where is P/U?

anyhow use find function and get the row of P/U and selet rows next to that and till the end and sort

simmonsv · Sep 17, 2013

What I ended up doing is coping the work sheet to a new sheet doing a filter to delete the rows I didn't want, resort the remaining rows and copy pasting to the original sheet. It works but probably no the best use of code. Thank you for your feedback, I always appreciate this site and those that are so much more knowledgeable than I. I do have one other issued, I have code to find the last row on a sheet and now I want to go to the next empty row and copy from the previous row. Below is the code I have but am stumped on how to get to the next row below the last. I have two total rows, one of which I'll delete.' Use column A to determine where the last row of data occurs
myLastRow = Cells(Rows.Count, "A").End(xlUp).Row

For myRow = 2 To myLastRow
If Cells(myRow, "A") Like "Grand*" Then
' myRow +1.Select This is where I want to go to the next row down for myrow
' Copy value from column above
Cells(myRow, "H") = Cells(myRow - 1, "I")
Cells(myRow, "J") = Cells(myRow - 1, "K")
Cells(myRow, "L") = Cells(myRow - 1, "M")
Cells(myRow, "N") = Cells(myRow - 1, "O")
Cells(myRow, "P") = Cells(myRow - 1, "Q")
Cells(myRow, "R") = Cells(myRow - 1, "S")
Cells(myRow, "T") = Cells(myRow - 1, "U")
Cells(myRow, "V") = Cells(myRow - 1, "W")
Cells(myRow, "X") = Cells(myRow - 1, "Y")
Cells(myRow, "Z") = Cells(myRow - 1, "AA")
Cells(myRow, "AB") = Cells(myRow - 1, "AC")
Cells(myRow, "AD") = Cells(myRow - 1, "AE")
Else
If Cells(myRow, "A") = cell.Value & " Total" Then
Cells(myRow, "A").EntireRow.ClearContents
End If
End If

Next myRow Below is a sample of the end of my worksheet.
[TABLE="width: 6435"]
<tbody>[TR]
[TD]GORDMANS #044[/TD]
[TD]3[/TD]
[TD]10035672[/TD]
[TD]P2516 BLANK YELLOW CLEARANCE[/TD]
[TD]Light Yellow[/TD]
[TD]BOX[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]3[/TD]
[TD] $ 128.85 [/TD]
[TD]2[/TD]
[TD] $ 85.90 [/TD]
[TD]2[/TD]
[TD] $ 85.90 [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]2[/TD]
[TD] $ 85.90 [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]2[/TD]
[TD] $ 85.90 [/TD]
[TD]1[/TD]
[TD] $ 42.95 [/TD]
[TD] $ 515.40 [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GORDMANS #044[/TD]
[TD]Needed[/TD]
[TD]10097581[/TD]
[TD]XLPROIR INK ROLLER F/XL265P GUN[/TD]
[TD]Light Yellow[/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]10[/TD]
[TD] $ 45.00 [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD]0[/TD]
[TD] $ - [/TD]
[TD] $ 45.00 [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GORDMANS #044 Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]50[/TD]
[TD] $ 1,290.71 [/TD]
[TD]110[/TD]
[TD] $ 3,142.38 [/TD]
[TD]125[/TD]
[TD] $ 3,268.06 [/TD]
[TD]70[/TD]
[TD] $ 1,697.69 [/TD]
[TD]105[/TD]
[TD] $ 2,145.01 [/TD]
[TD]71[/TD]
[TD] $ 1,453.08 [/TD]
[TD]71[/TD]
[TD] $ 1,244.19 [/TD]
[TD]82[/TD]
[TD] $ 1,461.98 [/TD]
[TD]62[/TD]
[TD] $ 1,564.30 [/TD]
[TD]51[/TD]
[TD] $ 1,147.59 [/TD]
[TD]98[/TD]
[TD] $ 1,558.74 [/TD]
[TD]99[/TD]
[TD] $ 1,705.52 [/TD]
[TD] $ 21,679.26 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]50[/TD]
[TD] $ 1,290.71 [/TD]
[TD]110[/TD]
[TD] $ 3,142.38 [/TD]
[TD]125[/TD]
[TD] $ 3,268.06 [/TD]
[TD]70[/TD]
[TD] $ 1,697.69 [/TD]
[TD]105[/TD]
[TD] $ 2,145.01 [/TD]
[TD]71[/TD]
[TD] $ 1,453.08 [/TD]
[TD]71[/TD]
[TD] $ 1,244.19 [/TD]
[TD]82[/TD]
[TD] $ 1,461.98 [/TD]
[TD]62[/TD]
[TD] $ 1,564.30 [/TD]
[TD]51[/TD]
[TD] $ 1,147.59 [/TD]
[TD]98[/TD]
[TD] $ 1,558.74 [/TD]
[TD]99[/TD]
[TD] $ 1,705.52 [/TD]
[TD] $ 21,679.26 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="68"></colgroup>[/TABLE]

venkat1926 · Sep 18, 2013

It is always better to give a small extract of your data sheet and also sheet what result would be . then it is possible understand the requiorement and easier to test the code give btyou. so I have designed trivial data sheet given below .
Sheet1

*	A	B	C
hdng1	hdng2	hdng3

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]36[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]68[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]34[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]45[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]91[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]74[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]44[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]64[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]10[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

now it is not clear what you want. do yu want A2 to c10 cut copied to A11 onwards.

FIRST COPY SHEETS 1 TO SHEET 2 - IMPORTANT

now try this macro

Code:

Sub test()
    Dim r As Range, lastcell As Range
    Worksheets("sheet1").Cells.Clear
    Worksheets("sheet2").Cells.Copy Worksheets("sheet1").Range("a1")
    Worksheets("sheet1").Activate
    Set r = Range(Range("A2"), Range("A2").End(xlToRight).End(xlDown))
    MsgBox r.Address
    Set lastcell = Range("A2").End(xlDown).Offset(1, 0)
    r.Cut
    lastcell.Select
    ActiveSheet.Paste




End Sub

if this is not what you want then take my data and give expected result

Looping thru rows and when a specific value is found in column 'N' sort all remaining rows in alpha order from column

simmonsv

Board Regular

venkat1926

Well-known Member

simmonsv

Board Regular

venkat1926

Well-known Member

Similar threads

Share this page

Looping thru rows and when a specific value is found in column 'N' sort all remaining rows in alpha order from column

simmonsv

Board Regular

venkat1926

Well-known Member

simmonsv

Board Regular

venkat1926

Well-known Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock