Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell content removal
I was wondering if someone could help me with a macro where it would remove
cell contents if certain criteria is not met. Weekly i create a new file to be distributed that I need to clean up up cell contents that does not meet specific criteria. The criteria I need to meet is the following, column name listed first, than criteria, for all others I will need the cell contents removed for the column name listed below. Column Name and Criteria where cell contents are needed for three columns within worksheet: Year = 2008 or greater Defect = "Yes" Human Error = "Yes or "No" Status = "Closed", or" Closed - No Action" or "Contionous" If this criteria is not met above than remove cell contents in the following columns: "Project", "Details", and "Cost" I am thinking I need some type of dowhile loop, but not real fluent on VBA. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Content Removal | Excel Programming | |||
Removal of cell contents | Excel Programming | |||
removal of first digit on left in cell | Excel Programming | |||
Removal of cell objects | Excel Discussion (Misc queries) | |||
When content of a cell changes, content of another deletes | Excel Programming |