| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Clear Cells and Delete Rows
I am trying to automate the formatting of an Excel output file so that I can
send it to clients. To do this I need a macro that will: 1. Check each Cell in Column J 2. If Cell in Column J is = to "H" I need to clear the Cells in Column J & K for that Row. 3. If Cell in Column J is = to "T", "R", "D", or "P" I need to delete the the entire row. I would appreciate any and all help with this. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete rows with cells less than user-inputed time | Excel Programming | |||
| How do I only delete/clear the visible cells in a filtered list? | Excel Worksheet Functions | |||
| Help to clear data & delete rows | Excel Programming | |||
| Delete/clear a cell based on another cells contents | Excel Programming | |||
| Macro to delete rows with text cells | Excel Programming | |||
Threaded Mode
