Hi DocAElstein,

Sorry about replying so late. I cannot access the website from my work.

The team leader inputs the data in columns B, C, D and G (via a form)

He inputs S.no. 1 to 8 on 16 and ran the macro on 16MAR18.

He inputs S.no. 9 to 16 and ran the macro on 17MAR18

He inputs S.no. 17 to 24 and ran the macro on 18MAR18

He inputs S.no. 25 to 28 and ran the macro on 19MAR18

He inputs S.no. 29 to 36 and also a new member Sangeeta and ran the macro on 20MAR18

In other words, when the new data is input, column F is blank and the cells get updated on the day the macro is run.

The individual files have dates in column F of the day the macro is run for different records.

Hope this gives a better picture.


Regards
Raghavendra


S1 with clear expalination.zip