and that result needs to be added in column "A", each serial in new row, other columns in range to be populated with values from other textboxes. In userform I added 3 textboxes for that problem, in first I would type serial number and in the other two, the first and the last number for incrementation.įor example: Serial number is 6000188 first numer 1 last number 19, and expected result: 6000188-1, 6000188-2, 6000188-3, 6000188-4. I use 7 columns ("A:G") and X rows, I created a userform to help me distribute data to the desired worksheet ( serial number, name, quantity, status, date of production) all that work as wanted, but I have problem with serial number. Sample workbook in this link: I have a workbook for my inventory with 33 worksheets, each sheet for one product.
#Vba auto increment file name changer how to#
I was looking at forums for code or at least idea how to run this, but with no luck.
0 kommentar(er)
