Hi folks,
I am trying to create a rule for auto fill for the log sheet in my lab. As we can see in the attached image, the serial number (red color) in column A, have to come in column G, in between some other remarks.
For a new day, what I am doing currently is, I copy the entire lines, update the column of serial number by increment by 1. Once i get the new set of serial numbers, I manually replace each older serial number in column G with the new one. If there is an option to setup an auto-update, it could have been so easier.
Thanks.
book1.PNG
Bookmarks