Copy entire row when cell content has changed

[bting]

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.

[Steffen Thomsen]

Try this

Please Login or Register  to view this content.

[bting]

Thank you very much, it worked perfectly!