Home

VBA to move rows in a sheet based on the project status - with a twist

%3CLINGO-SUB%20id%3D%22lingo-sub-678603%22%20slang%3D%22en-US%22%3EVBA%20to%20move%20rows%20in%20a%20sheet%20based%20on%20the%20project%20status%20-%20with%20a%20twist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678603%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20very%20similar%20issue%20to%20the%20original%20poster%20of%20this%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELink%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FVBA-to-Move-rows-in-a-sheet-based-on-the-project-Status%2Ftd-p%2F186359%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FVBA-to-Move-rows-in-a-sheet-based-on-the-project-Status%2Ftd-p%2F186359%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F37127%22%20target%3D%22_blank%22%3E%40Matt%20Mickle%3C%2FA%3E%20had%20a%20solution%20that%20seems%20to%20fit%20my%20needs%20except%20for%20one%20aspect.%20In%20the%20destination%20worksheet%2C%20I%20would%20like%20to%20find%20out%20if%20it's%20possible%20to%20have%20the%20rows%20added%20in%20a%20way%20that%20automatically%20sorts%20them%20by%20a%20value%20in%20column%20A.%20That%20way%2C%20when%20I%20go%20to%20the%20%22projects%20completed%22%20worksheet%20(or%20whatever%20I%20end%20up%20naming%20it)%2C%20the%20projects%20are%20all%20listed%20in%20numerical%20order%20(we%20number%20our%20projects%20numerically)%2C%20even%20if%20they%20are%20not%20completed%20numerically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20that%20it%20matters%2C%20but%20I%20don't%20need%20as%20many%20columns%20as%20the%20original%20poster%20in%20my%20reference%20link.%20I%20need%20about%206%20columns%20of%20data%20plus%20one%20column%20to%20designate%20the%20status.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20could%20help%20out%20with%20that%2C%20I%20would%20greatly%20appreciate%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3EAndrew%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-678603%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Andrew_Schenk
Occasional Visitor

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