When status has changed, move to new tab

**maddog9486** · 02-19-2009, 12:01 PM

Hey everyone, ok this is what I'm wanting to do. In my spreadsheet I have column B which has a drop down list using "open" and "closed" as the choices. Whenever someone selects the closed option, I would like for that row to be moved to the next blank row on the tab called CLOSED. Is this possible? I was thinking that if it was it would require some kind of coding. I have attached my spreadsheet for you to look at. Thanks in advance.

**Kenneth Hobson** · 02-19-2009, 12:55 PM

Right click your Open sheet's tab, View Code, and paste:

Please Login or Register  to view this content.

When you edit column 4 and it is not empty, it will copy and paste the row and delete that row.

**maddog9486** · 02-19-2009, 03:14 PM

works perfectly....thanks Kenneth.

When status has changed, move to new tab

LinkBack

Thread Tools

Rate This Thread

Display

When status has changed, move to new tab

Re: When status has changed, move to new tab

Re: When status has changed, move to new tab

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions