How to move completed row to the bottom of the same worksheet?

[Pancakey]

Hello,

I am trying to figure out how to automatically move rows towards the bottom of the same spreadsheet if the PO Status is set to "Completed," and gray it out. I don't want it to go too far down, but maybe around 10-15 rows down/after the current data. Is there a way to do this without using VBA? I am hoping to transition the data to the online version of Excel and would like to know what my options are. Thank you!

 

[kevin9999]

Is there a way to do this without using VBA?

Not as far as I know. Let us know if VBA is an option you'd consider.