Hello,
I have a file with 2 worksheets: one worksheet is labels I designed, each printing page containing 4 labels of a product. In the other worksheet, I have information for each page how many copies of each page I should print. In the example file, in "data" there is information that I need 5 copies of page 1, it means I need to print page 1 five times, then to print page 2 - twice, page 4 -4 times, etc...
As I can have up to 60 different products (so 60 pages to print a different amount of times!), it can be a bit time consumming to do it manually. I would like to automatize this process with a bit of vba and looking for some help here
Thank you in advance
I have a file with 2 worksheets: one worksheet is labels I designed, each printing page containing 4 labels of a product. In the other worksheet, I have information for each page how many copies of each page I should print. In the example file, in "data" there is information that I need 5 copies of page 1, it means I need to print page 1 five times, then to print page 2 - twice, page 4 -4 times, etc...
As I can have up to 60 different products (so 60 pages to print a different amount of times!), it can be a bit time consumming to do it manually. I would like to automatize this process with a bit of vba and looking for some help here
Thank you in advance