| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up an automatic delete or move of a row of data?
I have a job summary that lists the status of my projects. I want to move
the data and close up the gaps in the spreadsheet as I change the status to "complete". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up an automatic delete or move of a row of data?
You need to provide more information. For example, how do you change the
status to complete and where do you want to move the data to? Regards Rowan "Zo" wrote: I have a job summary that lists the status of my projects. I want to move the data and close up the gaps in the spreadsheet as I change the status to "complete". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up an automatic delete or move of a row of data?
I have a list that identifies the "status" of the project (i.e. "incomplete,
"in progress," etc.). When the status is changed to "complete", I want that row to go away. "Rowan Drummond" wrote: You need to provide more information. For example, how do you change the status to complete and where do you want to move the data to? Regards Rowan "Zo" wrote: I have a job summary that lists the status of my projects. I want to move the data and close up the gaps in the spreadsheet as I change the status to "complete". |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up an automatic delete or move of a row of data?
You could use a change event similar to this. SAVE your data before
testing this. Rows will be deleted with no way to retrieve them! Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count = 1 Then If Target.Value = "Complete" And _ Target.Column = 1 Then 'change column as required Target.EntireRow.Delete End If End If End Sub This is worksheet event code. Right click the sheet tab, select view code and paste the event in there. This assumes you list is in column A. If not change Target.Column = 1 to the correct column. Regards Rowan Zo wrote: I have a list that identifies the "status" of the project (i.e. "incomplete, "in progress," etc.). When the status is changed to "complete", I want that row to go away. "Rowan Drummond" wrote: You need to provide more information. For example, how do you change the status to complete and where do you want to move the data to? Regards Rowan "Zo" wrote: I have a job summary that lists the status of my projects. I want to move the data and close up the gaps in the spreadsheet as I change the status to "complete". |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up an automatic delete or move of a row of data?
This thread did not change anything...
"Zo" wrote: I have a job summary that lists the status of my projects. I want to move the data and close up the gaps in the spreadsheet as I change the status to "complete". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| HELP REF. NEW DATA ONLY AS i MOVE TO ANY CELL IN THE NEW ROW/RANGE | Charts and Charting in Excel | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Must move mouse before entering data? | Excel Discussion (Misc queries) | |||
| How to move data on worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
