I am trying to create a loop to enter a number on sheet2 or "Run" in cell E2. This number will begin with 1 and count up until it has reached the max ID value that is found in Column B of the "Setup" Tab. Before the number changes on the run tab I would like it to timestamp and then after it has completed its process it would also time stamp. In column O and P on the Setup sheet is where these time stamps would occur. Being that the data or ID's start on row 3 the first time stamp will fall on row 3, however If someone is savvy enough they would know that ID 1 falls on row 3 so time stamp start will go in O3 of Setup and End Stamp in P3.

Currently I write out each one and there are other things happening before and after this each time but they are set processes to other workbooks based on these selections. I can and will likely have written all of the IDs out in a method but would like to venture as far away from hardcoding as possible... so if you are reading this and any of this happens to make sense and you would like to take a stab at it I am open to all suggestions!

Workbooks("ProcessDepartments.xlsm").Sheets("Setup").Range("O3").Value = Now()
Workbooks("ProcessDepartments.xlsm").Sheets("Run").Range("E2").Value = "1"
Process
Workbooks("ProcessDepartments.xlsm").Sheets("Setup").Range("P3").Value = Now()

If you need a sample file to work with let me know I can clear out what is there and make it generic enough to work, but I am hoping someone here will be savvy with loops enough that this will be a cake walk and you will roll your eyes at my ignorance in this situation

Cheers