Hi,
I am looking for some help in automating a copy on paste of a list of values, Repeating a specific line a number of times before moving to the next line.
An example of the input data would be
From this data, I would like to copy this data to a new sheet, I would like the lines repeating in the new sheet based on the value in "Labels Required" without the output looking like the below.
I would assume the VBA would be best suited to handle this, but I have no grasp of it to be able to come close to what I want it to accomplish.
Column references would never change with the data, though it could be created as a table if that's easier.
Any help would be appreciated.
Cheers,
I am looking for some help in automating a copy on paste of a list of values, Repeating a specific line a number of times before moving to the next line.
An example of the input data would be
| A | B | C | D | E | F | G | H | I | J |
| Material | Plant | Sloc | Deliv.Qty | Un | Picked Qty | Un2 | Gross Weight | Description | Labels Required |
| Material 1 | 6200 | 620 | 2 | PC | 2 | KG | 18 | Description 1 | 2 |
| Material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 8 |
| Material 3 | 6200 | 620 | 8 | PC | 8 | KG | 1.84 | Description 3 | 4 |
From this data, I would like to copy this data to a new sheet, I would like the lines repeating in the new sheet based on the value in "Labels Required" without the output looking like the below.
| A | B | C | D | E | F | G | H | I | J |
| Material | Plant | Sloc | Deliv.Qty | Un | Picked Qty | Un2 | Gross Weight | Description | Labels Required |
| Material 1 | 6200 | 620 | 2 | PC | 2 | KG | 18 | Description 1 | 1 of 2 |
| Material 1 | 6200 | 620 | 2 | PC | 2 | KG | 18 | Description 1 | 2 of 2 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 1 of 8 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 2 of 8 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 3 of 8 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 4 of 8 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 5 of 8 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 6 of 8 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 7 of 8 |
| material 2 | 6200 | 620 | 8 | PC | 8 | KG | 14.4 | Description 2 | 8 of 8 |
| Material 3 | 6200 | 620 | 8 | PC | 8 | KG | 1.84 | Description 3 | 1 of 4 |
| Material 3 | 6200 | 620 | 8 | PC | 8 | KG | 1.84 | Description 3 | 2 of 4 |
| Material 3 | 6200 | 620 | 8 | PC | 8 | KG | 1.84 | Description 3 | 3 of 4 |
| Material 3 | 6200 | 620 | 8 | PC | 8 | KG | 1.84 | Description 3 | 4 of 4 |
I would assume the VBA would be best suited to handle this, but I have no grasp of it to be able to come close to what I want it to accomplish.
Column references would never change with the data, though it could be created as a table if that's easier.
Any help would be appreciated.
Cheers,
