Deleting

Kelvin Maed

New member
Joined
Oct 16, 2012
Messages
2
Reaction score
0
Points
0
Location
Bristol, United Kingdom, United Kingdom
Hi,

The below code is an export from my stock program.

The code is 3 columns across and hundreds of rows down

what i want;

to remove the row that contains for example;

cell A10 contains "000000000000000007: DASH COKE / DIET" so to remove this row completely
cell A14 contains "000000000000000012: KICK" remove this row completely
cell A18 contains "000000000000000029: GOL VODKA & KICK" keep this row.

the cell changes with what the people have sold, but the text always stays the same, so i am looking to delete rows when they contain certain texts.

thanks

Code:
PLU Journal Report Showing Journal PLUs, Grouped By Clerks (Numbered)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Date: 08/09/2012[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Place: All Sites[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Description[/TD]
[TD]PLUs[/TD]
[/TR]
[TR]
[TD]Clerk (Numbered) 1: STEVE MARTIN (ECR Network 101:)[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000000000000000004: BABY TONIC[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000007: DASH COKE / DIET[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]000000000000000008: DASH LEMONADE[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]000000000000000009: DASH LIME[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]000000000000000012: KICK[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000028: SGL VODKA & KICK[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]000000000000000029: GOL VODKA & KICK[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]000000000000000033: JUNGBOMB[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]000000000000000044: GOL ODESSA VODKA[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]000000000000000045: GOL JACK DANIELS[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]000000000000000047: GOL SOUTHERN COM[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]000000000000000052: GOL AMARETTO[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]000000000000000053: GOL ARCHERS[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000058: CORKYS APPLE[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]000000000000000062: GOL GORDONS GIN[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000065: SAMBUCA[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]000000000000000066: CORKYS FLAVOURS[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]000000000000000073: TEQUILA[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]000000000000000088: K2 FLAVOURS[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000089: VK FLAVOURS[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]000000000000000090: VK BLUE[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]000000000000000093: BULMERS 330ml[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000099: STELLA[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]000000000000000100: COORS LITE[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000101: BECKS[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]000000000000000102: CARLING 500ml[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000103: BUDWEISER[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]000000000000000105: CARLING PINT[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000106: COORS LITE PINT[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000107: OLDE ENGLISH PIN[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000124: CHATEAU CHARMAIN[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]000000000000000160: SGL ODESSA VODKA[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]000000000000000161: SGL JACK DANIELS[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]000000000000000162: SGL MALIBU[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000163: SGL SOUTHERN COM[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000164: SGL AMARETTO[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000165: SGL ARCHERS[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000169: SGL CAPTAIN MORG[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1: MIKE GRINTER (ECR Network 101:)[/TD]
[TD]278[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Clerk (Numbered) 2: CHEVY CHASE (ECR Network 101:)[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000000000000000003: PEPSI / DIET BOT[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]000000000000000005: DASH ORANGE[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]000000000000000006: DASH CRANBERRY[/TD]
[TD]4[/TD]
[/TR]
[/TABLE]
 
Have you tried using the Autofilter to filter out the records you want to delete? Or are you trying to automate the process?
 
I would add a simple helper column with a formula that checks for that code, such as

=OR(A2={"000000000000000007: DASH COKE / DIET","000000000000000012: KICK","000000000000000029: GOL VODKA & KICK"})

and filter for TRUE on that column. That would facilitate easy automaton.
 
As long as it's a short list, for sure.I'm assumign it's a list of non-stocked products that he's trying to remove, so maybe leveraging a VLOOKUP against a table of those products would be even better?
 
Back
Top