worksheet change - cut row, move to desired sheet, delete original row

I am working some different worksheet changes and can't seem to get this one to fire off properly. We work with sale dates and often times these dates get either canceled completed or the sale is re-scheduled for a new date.

When these sales are canceled i want to be able to move that entire row from our "master" sheet to our "futures" tab. I am not sure if its because i have conflicting worksheet changes or if my code is incorrect.

Please Login or Register  to view this content.

Originally Posted by jaslake

Hi dsmith616

A little bit of both. Since I don't know your Data, you'll need to clean up the Cut/Paste part of the Code.

Please Login or Register  to view this content.

I've tried to use your code and now neither parts of the worksheet change are working. Is there anymore information I can provide that would be beneficial? I am also including a sample of what my worksheet looks like.

just as a quick summary of what we are attempting to accomplish:

1. When dates are added into the 'Submitted' column on the master tab the first worksheet change should fire setting an expiration date 60 days out.
2. When a sale date is removed from column A; we would like that entire row to be moved from master to futures while deleting the original entry in the master leaving only the newly moved entry in the futures tab

thanks in advance!

So I stumbled across this code snippet that almost does everything I need it to EXCEPT after it moves the data over to the new tab it does not delete the blank row left on the master tab

Please Login or Register  to view this content.

Originally Posted by jaslake

Hi dsmith616

Try this

Please Login or Register  to view this content.

sorry for the delayed response I was out on vacation and refused to work! LOL

Anyways, came back to this finally and just wanted to say it works PERFECTLY! thank you much!