Copy ActiveRow to another sheet

Hello,

I am trying to form a VBA code that will copy a row to another sheet if text appears in a cell. I keep getting object error when I try to run the code. Im not sure why as I thought if I 'Set' the sheets it would work for something like activerow.copy? I think that is where I am running into issues.

This code should: 1. Search column K in "Dashboard" for an X 2. if X is found then copy the row to sheet "Archive" in the first blank row. I tried writing this code from scratch so I am open to figuring out where exactly I am going wrong.

Please Login or Register  to view this content.

Thank you. That did resolve the issue but I actually ran into another one. To keep up with the forum rules I posted the question in another thread: https://www.excelforum.com/excel-pro...ml#post5531049

Kudos though as your solution worked but then I noticed other issues now that it is working.