Data validation on multiple sheets.

Hello,

I'm currently using this code:

Please Login or Register  to view this content.

to insert data validation on entries in a spreadsheet.

I then use a variation of this code to transfer entries from one sheet to the other, and perhaps back again:

Please Login or Register  to view this content.

If I take an entry, move it to a different sheet, and decide I want to move that entry back to its original sheet, how can I return the data validation back to the cell?

I have attached my workbook.
The password, when prompted, is "MillSteel"

I want data validation to only be present on "Current ____" sheet. not "History ___"

uhm.

So. if you are on the homesheet and you fill out the maintenance report, it enters it onto the 'Current Maintenance' worksheet. Once added, the entry's A column becomes a drop down menu with 4 different choices.

Then, the user can write the word 'y' into g, and press 'Update History', which transfers rows containing y in the G column to the sheet "History Maintenance." once the entry has been transferred to the history sheet, the A column is now just text, and no longer a drop down menu (which is what I want it to do).

If an entry has been posted to the History Sheet by mistake, then the user can change the 'y' in the g column to an 'n' and then press the "Undo History" button. this will remove all rows with 'n' in the g column and move it back to the 'Current History" sheet. once moved back to the current sheet, the A column remains as text, and the drop down menu is still not there (this is not what I want it to do- I want there to be a drop down menu in the A column for any entry that is on the "Current Sheet")

would it be easier to just do data validation through the worksheet and not by macro?

BUMP- please help!