I would like to do the following:
Insert a new row:
IF drop down in Column D = MRKTG, then auto fill Column A with next sequence in a range of 100-199.
IF drop down in Column D = FIN, then auto fill Column A with next sequence in a range of 200-299.
and so on.

Autofill colA.xlsx

Is this possible?
Purpose: Achieve an easy way to recognize when a department adds a tasks to project plan; ie- yesterday they had 100-150, today I see 100-160.