Wondering if there's a macro that can do this when i press a button.
In spreadsheet "Complete Backlog"
Autofilter on
Show rows where WIP Status (Column K) equals "Closed"
Cut rows
Paste into next available row of "Closed Jobs" spreadsheet. No overwrites.
Or you could switch step 5 and 6 so...