Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deeting rows based on entry in a cell
Hi,
I have a user defined function that places a key word in the last column of data, making the data easier to sort. There are hundreds of records but in column F the function places the key word from 3 choices - Processed, Pending, Finished. How can I set up a macro to delete all the records apart from "Processed". OR having allocated the keyword using the function move all the Pending records to a separate sheet and the Finished records to a third sheet and then tidy up any gaps. Thanks Gaz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deeting rows based on entry in a cell
Gazza,
When deleting entire rows of data, I find it easier to start from the bottom and work up. Sub ZapEm() LastRow = 1000 ' You should improve this by defining the size of your range. For x = LastRow to 1 step -1 if Range("F" & x).Value < "Processed" then Range(X & ":" & x).entirerow.delete End If End sub Gazza wrote: Hi, I have a user defined function that places a key word in the last column of data, making the data easier to sort. There are hundreds of records but in column F the function places the key word from 3 choices - Processed, Pending, Finished. How can I set up a macro to delete all the records apart from "Processed". OR having allocated the keyword using the function move all the Pending records to a separate sheet and the Finished records to a third sheet and then tidy up any gaps. Thanks Gaz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
Moving Rows to another sheet based on an entry | Excel Worksheet Functions |