Forum Discussion
LenaGonzo
Feb 21, 2024Copper Contributor
How to automatically move rows from one sheet to another in Excel and populate newest at top
Hello, I currently have an Excel spreadsheet and code to automatically move a row when I change the status in a dropdown to "completed" to move the row from Sheet1 into the Completed Sheet. ...
JKPieterse
Feb 22, 2024Silver Contributor
LenaGonzo Rather than using a macro, why not add a status column to your data, convert your data range to a table (Insert, Table) and then add a slicer to your table for the Status column. That makes it very easy to filter for the status.