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 ...
OfficeScriptMsft_alex
Microsoft
Microsoftjavawn You should be able to accomplish this via the use of Office Scripts. If you look at the automate tab, you should be able to find sample scripts, including one called "Move Rows Between Tables". You should be able to modify this sample to do what you want.
Then, you'll be able to simply run this script to move rows between sheets, and delete them as you have asked.
I hope this helps!