Hello all,
I have a very similar issue to the original poster of this query.
Link: https://techcommunity.microsoft.com/t5/Excel/VBA-to-Move-rows-in-a-sheet-based-on-the-project-Status...
@Matt Mickle had a solution that seems to fit my needs except for one aspect. In the destination worksheet, I would like to find out if it's possible to have the rows added in a way that automatically sorts them by a value in column A. That way, when I go to the "projects completed" worksheet (or whatever I end up naming it), the projects are all listed in numerical order (we number our projects numerically), even if they are not completed numerically.
Not that it matters, but I don't need as many columns as the original poster in my reference link. I need about 6 columns of data plus one column to designate the status.
If anyone could help out with that, I would greatly appreciate it.
Thanks!
Andrew
