I have a task spreadsheet. When my task changes to complete I want to pull
to another sheet and hide it's view from the main sheet. Does anyone have
any suggestions?

You mention a task sheet and a Main sheet.

"Pull" what to which "other sheet"

How will you know when the task is complete and which cells would be copied or
cut to the other sheet to be hidden?

Have you done this manually?

If so, maybe record a macro whilst doing it.

Or possibly event code to do it automatically when a certain cell turns to "task
complete".


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 11:48:02 -0700, Mindy
wrote:

I have a task spreadsheet. When my task changes to complete I want to pull
to another sheet and hide it's view from the main sheet. Does anyone have
any suggestions?

I have a main spreadsheet with 7 columns. (I have created a list to sort
through tasks, action officers, etc.) One of those columns is status. I
have put in drop down lists to pick the status ( complete, new, working..)
When Complete is selected I would like the column to hide itself and then
populated another sheet that has all the completed tasks(only) in it.

"Gord Dibben" wrote:

You mention a task sheet and a Main sheet.

"Pull" what to which "other sheet"

How will you know when the task is complete and which cells would be copied or
cut to the other sheet to be hidden?

Have you done this manually?

If so, maybe record a macro whilst doing it.

Or possibly event code to do it automatically when a certain cell turns to "task
complete".


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 11:48:02 -0700, Mindy
wrote:

I have a task spreadsheet. When my task changes to complete I want to pull
to another sheet and hide it's view from the main sheet. Does anyone have
any suggestions?

You want the column to hide itself or the row to hide itself?

I would say the row to be hidden and copied

For the row hiding see your other posting that you tacked onto someone else's
original.

To both copy the row to another sheet and hide the row use this code.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 6 And _
Target.Value = "complete" Then
With Target.EntireRow
.Copy Destination:=Sheets("Completed") _
.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0)
.Hidden = True
End With
End If
enditall:
Application.EnableEvents = True
End Sub


Gord

On Tue, 10 Jun 2008 12:37:00 -0700, Mindy
wrote:

I have a main spreadsheet with 7 columns. (I have created a list to sort
through tasks, action officers, etc.) One of those columns is status. I
have put in drop down lists to pick the status ( complete, new, working..)
When Complete is selected I would like the column to hide itself and then
populated another sheet that has all the completed tasks(only) in it.

"Gord Dibben" wrote:

You mention a task sheet and a Main sheet.

"Pull" what to which "other sheet"

How will you know when the task is complete and which cells would be copied or
cut to the other sheet to be hidden?

Have you done this manually?

If so, maybe record a macro whilst doing it.

Or possibly event code to do it automatically when a certain cell turns to "task
complete".


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 11:48:02 -0700, Mindy
wrote:

I have a task spreadsheet. When my task changes to complete I want to pull
to another sheet and hide it's view from the main sheet. Does anyone have
any suggestions?

One other thing I should mention.

You can hide the "Completed" sheet and it will still be updated.


Gord

On Tue, 10 Jun 2008 14:41:06 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

You want the column to hide itself or the row to hide itself?

I would say the row to be hidden and copied

For the row hiding see your other posting that you tacked onto someone else's
original.

To both copy the row to another sheet and hide the row use this code.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 6 And _
Target.Value = "complete" Then
With Target.EntireRow
.Copy Destination:=Sheets("Completed") _
.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0)
.Hidden = True
End With
End If
enditall:
Application.EnableEvents = True
End Sub


Gord

On Tue, 10 Jun 2008 12:37:00 -0700, Mindy
wrote:

I have a main spreadsheet with 7 columns. (I have created a list to sort
through tasks, action officers, etc.) One of those columns is status. I
have put in drop down lists to pick the status ( complete, new, working..)
When Complete is selected I would like the column to hide itself and then
populated another sheet that has all the completed tasks(only) in it.

"Gord Dibben" wrote:

You mention a task sheet and a Main sheet.

"Pull" what to which "other sheet"

How will you know when the task is complete and which cells would be copied or
cut to the other sheet to be hidden?

Have you done this manually?

If so, maybe record a macro whilst doing it.

Or possibly event code to do it automatically when a certain cell turns to "task
complete".


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 11:48:02 -0700, Mindy
wrote:

I have a task spreadsheet. When my task changes to complete I want to pull
to another sheet and hide it's view from the main sheet. Does anyone have
any suggestions?

Yes, that is exactly what I wanted it to do. However, I never had to run a
macro in excel, and I am not sure how or what is the best way to do it. Can
you walk me thru some steps? Thanks a bunch!

"Gord Dibben" wrote:

One other thing I should mention.

You can hide the "Completed" sheet and it will still be updated.


Gord

On Tue, 10 Jun 2008 14:41:06 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

You want the column to hide itself or the row to hide itself?

I would say the row to be hidden and copied

For the row hiding see your other posting that you tacked onto someone else's
original.

To both copy the row to another sheet and hide the row use this code.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 6 And _
Target.Value = "complete" Then
With Target.EntireRow
.Copy Destination:=Sheets("Completed") _
.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0)
.Hidden = True
End With
End If
enditall:
Application.EnableEvents = True
End Sub


Gord

On Tue, 10 Jun 2008 12:37:00 -0700, Mindy
wrote:

I have a main spreadsheet with 7 columns. (I have created a list to sort
through tasks, action officers, etc.) One of those columns is status. I
have put in drop down lists to pick the status ( complete, new, working..)
When Complete is selected I would like the column to hide itself and then
populated another sheet that has all the completed tasks(only) in it.

"Gord Dibben" wrote:

You mention a task sheet and a Main sheet.

"Pull" what to which "other sheet"

How will you know when the task is complete and which cells would be copied or
cut to the other sheet to be hidden?

Have you done this manually?

If so, maybe record a macro whilst doing it.

Or possibly event code to do it automatically when a certain cell turns to "task
complete".


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 11:48:02 -0700, Mindy
wrote:

I have a task spreadsheet. When my task changes to complete I want to pull
to another sheet and hide it's view from the main sheet. Does anyone have
any suggestions?