Hi,
im unsure how to go about this but it should be possible with for loops / if statements i think.
i have a list of data on sheet("data") in columns A:C in the following format:
0001 | 12 | 01 |
0002 | 1 | 01 |
0003 | 4 | 02 |
0004 | 1 | 03 |
0005 | 6 | 04 |
0006 | 1 | 04 |
I need to copy everything with CountryCode 01 into range "label01" on Sheet("Labels") and repeat for each country code. I usually do this manually with copy/paste values but its very repetitive.
Though if there are more than 10 with same country code, rest will go on to the following label.
(label ranges are 3col x 10row)
example:
CountryCode: 01 - 6 rows (goes into range "label01")
CountryCode: 02 - 14 rows (10 goes into "label02" and 4 goes into "label03"
CountryCode: 03 - 8 rows (goes into "label04")
Any help would be appreciated.
Also posted at: