Kelvin Maed
New member
- Joined
- Oct 16, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
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
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:
|