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]
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Have you tried using the Autofilter to filter out the records you want to delete? Or are you trying to automate the process?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
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.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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?
 
Top