Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Deletion Using Text Trigger?
Is it possible to write a macro that can delete an entire
row of data if there is a certain text string in a particular column ? here is some sample data: A B C D 1 10 20 30 40 2 10.1 20.2 30.3 40.5 3 10.2 LC 30.7 -999.25 In this case, I would want to delete row 3. Any help would be greatly appreciated. I tried a couple of things, but I'm too embarrassed to post these attempts. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Deletion Using Text Trigger?
I have some macros that can do this at www.rubbershoe.com/deleterows.htm
"daved" wrote in message ... Is it possible to write a macro that can delete an entire row of data if there is a certain text string in a particular column ? here is some sample data: A B C D 1 10 20 30 40 2 10.1 20.2 30.3 40.5 3 10.2 LC 30.7 -999.25 In this case, I would want to delete row 3. Any help would be greatly appreciated. I tried a couple of things, but I'm too embarrassed to post these attempts. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIXED TEXT AFTER DELETION | Excel Discussion (Misc queries) | |||
add text in a cell to trigger a calculation | Excel Worksheet Functions | |||
macro trigger | Excel Discussion (Misc queries) | |||
trigger help | Excel Worksheet Functions | |||
Selective deletion of rows containing certain text. | Excel Worksheet Functions |