Hello,

After reviewing multiple codes, I can't seem to understand how to change other VBA codes to suite what I need to do. I'm having trouble with a Macro that copies an entire row of contents from column A:O when column C has the cell contents changed to: File Closed.

It should work like this:

Worksheet name is: "Tracking Sheet"
Cell(S) are a drop down list located in COLUMN C: Changed to "File Closed"
Copy entire row from A:O
Paste into new worksheet "Archive"
Delete Row in current worksheet

Also, I would like the row copied to go into a locked sheet "archive" so that another user wouldn't be able to go in and delete that data or change that data again.

Thanks for your help in advance.