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!
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!