i want to delete rows except certain valuesClosed

Question

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.

rizvisa1 · Answer

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.

I want to delete rows except certain values

1 response

Similar discussions

Subscribe To Our Newsletter!