Can this scenario be achieved in Excel so I get automatic ID column increment every time new row is inserted? (no matter in which place – at the beginning, in the middle or at the end of sheet):

1. There is a cell in excel (lets call it max_value) which holds integer value;
2. There is a column (column A) which holds IDs (all of these ids will be <= max_value);
3. After user inserts new row, no matter in which place, max_value gets first incremented by 1, and then column A in that new row is populated with max_value.