Help with cut/paste row macro (need VALUES)

[kahnailee]

I have the following code that works just fine, but I need it to paste the values as I'm referencing a table on the active sheet. I get an error in a calculated field of my destination sheet ("Master") since the row has been deleted via the macro.

Can someone either modify the existing code, or provide a new one that'll paste values instead? Code basically takes a row that has "Complete" in column A and cuts/pastes into another sheet.

Please Login or Register  to view this content.

[PCI]

Try

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.

[walruseggman]

Or if you don't want to copy and paste:

Please Login or Register  to view this content.

[kahnailee]

3 options, all work perfectly. Thank you!