| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move entire row if it contains specified text.
I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these are part of my validation list). If the action item in the cell is "Closed" I would like to move the entire row to row 9, without overriding what is there. So whatever was in row 9 would be in row 10 to make room for the closed action item. To make things more difficult, I have conditional formatting to grey out ever other row for reading ease. Any help would be appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move entire row to another sheet and deleting the old row only. | Excel Worksheet Functions | |||
| Move an entire row to another sheet | Excel Discussion (Misc queries) | |||
| check first cell in row, move entire row to sheet of that name | Excel Worksheet Functions | |||
| How do I un-"Group" my workbook; cannot see entire pane or move/re | Excel Discussion (Misc queries) | |||
| The Aarow keys move the entire sheet instead of to the next cell | Charts and Charting in Excel | |||
Threaded Mode
