I am trying to create a spreadsheet so that I can auto populate Cells depending on the quantity of parts requiring a serial number. Our serial number format looks like this "1102-0001" Basically 11 is the year, 02 is the month followed by 4 digits. For the next month the serial number would change to "1103-0001". Basically the month number changes and the 4 digits go back to 0001.
At present I have a front end page which I populate with all the part info required, then this is automatically copied into sheet 2. So sheet 2 is the long list of parts. Unfortunatley this is a pain if I have a part if we are making lots of exactly the same product but each one has to have its own serial number.
Ideally I need something where if the first serial number lets say is 1102-0001 and I could put 10 off in another cell, I would then click a button that says generate then a Macro would go and copy all the info from sheet 1 10 times onto the list on sheet 2 exactly the same but just changing the serial number accordingly, so the last one would be 1102-0010. Please let me know if any body else has tried to do something like this and has a solution.
At present I have a front end page which I populate with all the part info required, then this is automatically copied into sheet 2. So sheet 2 is the long list of parts. Unfortunatley this is a pain if I have a part if we are making lots of exactly the same product but each one has to have its own serial number.
Ideally I need something where if the first serial number lets say is 1102-0001 and I could put 10 off in another cell, I would then click a button that says generate then a Macro would go and copy all the info from sheet 1 10 times onto the list on sheet 2 exactly the same but just changing the serial number accordingly, so the last one would be 1102-0010. Please let me know if any body else has tried to do something like this and has a solution.