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.