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.