Question...

I have one worksheet to keep track of a certain kind of form with 3 different tabs: All, Open and Closed.

On the All tab, when I receive the form, I enter that number into the list in numerical order, adding a row if necessary. Then, I also enter that number into the list on the Open sheet.

When a form is closed, I enter a C in a column on the All sheet, and delete that number from the Open tab (to do that I simply use delete row). Then I need to enter the number I just deleted onto the Closed tab, which will have the same 3 columns as the All tab.

Is there a way to automatically delete the row from the Open tab and have it entered onto the Closed tab simply by marking it closed ('C') on the All tab?

I hope this makes some sort of sense. If anyone has any ideas, I'd like to try them!

Thanks,