I received some advice and can not find the response and didn't keep a copy. My problem is that I want to print labels from word by importing from excel as I currently export a great deal from our database into excel. What I would like to be able to do is have a macro that will automate the following task. I have tried but have spent many hours getting nowhere!!
The user needs to be able to enter a value (the amount of labels that need to be printed) and using a vlookup, select the product that needs the labels, which is stored in another worksheet. The problem is that i need to be able to store the same product details in the same amount of rows as defined by the user, hence the input value. This then when imported in word will give me for example 10 labels that have the same information on it.
I have solved this to some degree however, the problem I have is that I am unable to code the macro to start the process again with a another product (b) starting directly under the previous product (a). The difficulty is that each time a product is entered they may contain different values (product a require 2 labels, product b requires 15 labels) therefore I can't directly define a range of cells. Is there anyone that can assist me PLEASE?
The user needs to be able to enter a value (the amount of labels that need to be printed) and using a vlookup, select the product that needs the labels, which is stored in another worksheet. The problem is that i need to be able to store the same product details in the same amount of rows as defined by the user, hence the input value. This then when imported in word will give me for example 10 labels that have the same information on it.
I have solved this to some degree however, the problem I have is that I am unable to code the macro to start the process again with a another product (b) starting directly under the previous product (a). The difficulty is that each time a product is entered they may contain different values (product a require 2 labels, product b requires 15 labels) therefore I can't directly define a range of cells. Is there anyone that can assist me PLEASE?