Trying to create an auto-update rule

[elbyraju]

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

[FDibbins]

Hi, welcome to the forum

For the increment, try his...
=--LEFT(A2,LEN(A2)-1)+1&"A"
(this should cater for when you go past 9999)
Although, I notice you are not using A in col G, but other letters?

For the 2nd part, where are those extra parts coming from?
If they are from another cell, you could use something like...
=D2&A2&C2

[elbyraju]

Getting increment is not a problem, i usually drop down the serial number and right click-on bottom right of the cell and select fill series.

Each of the serial numbers represent a part. same part will be checked in 3 shifts (A,B and C respectively).

Time in and out for A shift will have separate columns whereas, time for B and C is recorded in remarks column.

And the other number in the remark column (3323,3421, 3521) refers to which place the parts belong to.

so these 6 lines of data, are like a template where most of it stays the same except for the serial number (column A and G)

[jindon]

VBA, if you like.

Please Login or Register  to view this content.

[elbyraju]

thanks for the reply, but unfortunately, i couldn't get it working. could you please explain?

[jindon]

When you click the button, Col.G numbers in red will be replaced with the number in col.A in the same row.

Isn't is what you wanted?

[FDibbins]

Getting increment is not a problem, i usually drop down the serial number and right click-on bottom right of the cell and select fill series.

Not sure how that would happen, but if it works for you, thats great

Each of the serial numbers represent a part. same part will be checked in 3 shifts (A,B and C respectively).

I dont see anything there to reference a shift - unless that is what is in col A?

Time in and out for A shift will have separate columns whereas, time for B and C is recorded in remarks column.

Still dont see where A comes into this, but OK

And the other number in the remark column (3323,3421, 3521) refers to which place the parts belong to.

So, where will that data come from? If you want to automate this, then why not automate as much as possible?

so these 6 lines of data, are like a template where most of it stays the same except for the serial number (column A and G)

[/QUOTE]
If the "changeable" data is shown somewhere, the rest can be calc'd