Do automatic numbering of rows in a Table (SQN, Cur. No) with a formula that reacts with Excel rows instead of cell ranges or values. This automatic numbering updates itself never showing an error and regardless of Table sorting.
Select a desired range of cells and paste the row above the selection into those cells by the press of a button instead of manually copy/pasting the data.