Is there a way to freeze the top 10 rown in a sheet, and have this frozen area show "unfinished" rows from the rest of the sheet.
Skjermbilde 2024-05-19 122127.png
Trying to illustrate with screenshot, as long as "Order complete" is blank, the unfinished order will be shown in frozen pane in top of sheet. When "Order Complete" is filled, the info is removed from top rows, but still remains in the document row it belongs?
Hope this makes sense, not sure how to express my needs, but if you have any suggestions I would appreciate it

Lars