I want to delete rows except certain values

Closed
vani - Jun 26, 2011 at 05:12 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2011 at 10:18 AM
Hi any one plzzzzzzz help me,

this sheet has 5 columns
column A COLUMN B COLUMN C COLUMN D COLUMN E
row 1 --- vegetable, CARROT APPLE PROFIT INDIA
ROW 2 --- FRUIT CARROT ORANGE LOSS JAPAN

Actually i need the row to contain only vegetable, carrot, potato, profit, india

even if any one value changes in that row, i want that row to be deleted

for eg, vegetable, carrot, potato, loss, india
the unwanted values may change in any column,
plz any one give me a complete coding
i dont know that much of VB.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 26, 2011 at 10:18 AM
I am so confused over your requirement. Why would you only keep "egetable, carrot, potato, profit, india " and not the other one Also I am not clear on what if only one item changes then. And that reminds me, how a change will occur. Is user typing it or it is a a load. You are looking for immediate processing or rather in a batch (or on demand kind of thing). Knowing VB or not knowing VB is secondary. First task is to have a robust well definded requirements.

Upload a sample while with sample data on some file sharing site. In that sample file show how the things are now and how you would like thing to be.
0