I have been looking at the SEQUENCE function but, if I understand it correctly, you need to enter and end point for how many sequential numbers you want Excel to autofill (e.g. 1 to 1000)? 

Is there a way to get Excel to autofill a sequential number when new data is entered in a Row?

For example, Column A is sequential numbers starting with ‘1’ (without the ‘ ‘ inverted commas) in A1, then 2 in A2 etc and every time data is entered in a new Row in Column B (for example), a new sequential number is entered automatically in the same Row in Column A? TIA

​I have been looking at the SEQUENCE function but, if I understand it correctly, you need to enter and end point for how many sequential numbers you want Excel to autofill (e.g. 1 to 1000)? Is there a way to get Excel to autofill a sequential number when new data is entered in a Row?For example, Column A is sequential numbers starting with ‘1’ (without the ‘ ‘ inverted commas) in A1, then 2 in A2 etc and every time data is entered in a new Row in Column B (for example), a new sequential number is entered automatically in the same Row in Column A? TIA  Read More

​