Forum Discussion
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. ...
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.
- Hi Jan Karel Pieterse, Will that move the completed rows from Sheet1 to the separate "completed" worksheet?
LenaGonzo No, it changes your current layout as it obsoletes the completed worksheet. I just wanted to make you look at this from a different perspective.
