Good day to you and thank you for looking into this.
I work in manufacturing. We have to produce labels for all the parts we build. As we have a new project starting i have a list of around 30 part numbers. For each part number i need to copy it twice in sheet 2 into cells A1 and A2. Cell A1 is already formatted into a barcode and cell a2 is formatted to a very small number in times new roman font. This produces a label which can be read by a handheld scanner and the operator.
Sheet 1 is more or less a simple request form. It has a drop down list of part numbers (B5) and a desired quantity to be printed (B6) it then has a hidden column (M) which splits cell B5 into 2 cells (M1 and M2) and runs a count (M4) which starts at 0.
Ultimately i would like to write a macro that when the user has selected their part number, quantity and hit button 1 the macro will copy cells M1 & M2 then copy and paster special (Values) into cells A1 and A2 on Sheet 2.
When its copied them into the first 2 cells it increases the count by 1 and checks it against the desired quantity. If its less then it copies them again but this time into cell A3 and A4 on sheet 2 and so on until the count (M5) matches the desired quantity (B6). Therefore if the user wanted 10 labels it should automatically fill from cell A1 to A20 in Sheet 2.
If anyone can help or you require further information regarding this then please let me know.
Thank you very much in advance for any help or support. And please feel free to recommend any changes to simplify (Eg. the loop until count(M5) = Desired quantity(B6)).
Ricky
I work in manufacturing. We have to produce labels for all the parts we build. As we have a new project starting i have a list of around 30 part numbers. For each part number i need to copy it twice in sheet 2 into cells A1 and A2. Cell A1 is already formatted into a barcode and cell a2 is formatted to a very small number in times new roman font. This produces a label which can be read by a handheld scanner and the operator.
Sheet 1 is more or less a simple request form. It has a drop down list of part numbers (B5) and a desired quantity to be printed (B6) it then has a hidden column (M) which splits cell B5 into 2 cells (M1 and M2) and runs a count (M4) which starts at 0.
Ultimately i would like to write a macro that when the user has selected their part number, quantity and hit button 1 the macro will copy cells M1 & M2 then copy and paster special (Values) into cells A1 and A2 on Sheet 2.
When its copied them into the first 2 cells it increases the count by 1 and checks it against the desired quantity. If its less then it copies them again but this time into cell A3 and A4 on sheet 2 and so on until the count (M5) matches the desired quantity (B6). Therefore if the user wanted 10 labels it should automatically fill from cell A1 to A20 in Sheet 2.
If anyone can help or you require further information regarding this then please let me know.
Thank you very much in advance for any help or support. And please feel free to recommend any changes to simplify (Eg. the loop until count(M5) = Desired quantity(B6)).
Ricky
