| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows on cell content?
I'm starting with a work schedule spreadsheet generated from an Access DB.
Column A contains employee names, B contains a segement code, and columns C:G contain times. It looks like this: EmpName Code 14-Feb 15-Feb Smith, Erin Work 10:00 10:00 Smith, Erin Break 12:00 12:00 Smith, Erin Work 12:15 12:15 Smith, Erin Lunch 14:15 14:15 Smith, Erin Work 14:30 14:30 Smith, Erin Break 16:30 16:30 Smith, Erin Work 16:45 16:45 I'm dealing with about 400 employees, each of whom have entries like this. I would like to be able to delete all of the rows in the used range that have "Work" in column B, leaving me with break and lunch times. Can this be accomplished with some VBA code? Much thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete cell content | Excel Discussion (Misc queries) | |||
| Delete rows by content | Excel Worksheet Functions | |||
| Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
| Delete Rows Based On Content | Excel Programming | |||
| Delete Rows Based On Content | Excel Programming | |||
Threaded Mode
