Forum Discussion
MOVE ENTIRE ROW BASED ON CELL VALUE TO NEW SHEET AND DELETE FROM OLD SHEET AUTIOMATICALLY
Hello, I have been having some trouble with getting this to work on my end. My goal is to have Column G (STATUS) after being marked as "Done" be moved to a separate sheet within the workbook ...
Can anyone help or give any insight on how to go about this?
Let me take a crack at the "insight" side of things.
I'm a believer in keeping transactional history in one place unless there's some compelling reason not to. And, for that matter, in making the history really complete. In this instance, for example, I see you already have three columns with dates. Why not change the column headed "Status" to read "DateDone" or just plain "Done" and record a date when it concludes.
This accomplishes:
- First, a more precise and complete history of whatever it is that you're tracking here (bookings?).
- Second, you can use the Data tool bar filter button, to hide all with Done "dates" in the past.
But you also always have at hand the full data set just by changing the setting on the filter. No switching back and forth between sheets.