stuart_sims
New member
- Joined
- Jul 22, 2015
- Messages
- 9
- Reaction score
- 0
- Points
- 0
Hi All,
I have been asked by a colleague for some help with a task and I am finding it rather difficult and know someone will have the answer, I'd love for you to share it with me please.
The workbook contains the following setup
Sheet 1 which contains multiple rows of data (the amount of rows of data will vary), address, qty, phone number, special instructions etc
Sheet 2 is a pre created delivery note.
I want to be able to do the following:
Press the print button (print button has been added to sheet 2) and sheet 2 will populate various data from cells on sheet 1 to compile a delivery note and print 2 copies. Once printed I want the code to look at the next line to see if there is any data if so, populate the next row of information onto the delivery note and print 2 copies. I want this to repeat all the way down until no more data is found. The print button will print from the default printer.
Someone please help, its been about 8 years since I last used VBA and am seriously struggling?
I have an example of the file which I can either post to this thread or send directly for you to look at.
Thanks in advance.
I have been asked by a colleague for some help with a task and I am finding it rather difficult and know someone will have the answer, I'd love for you to share it with me please.
The workbook contains the following setup
Sheet 1 which contains multiple rows of data (the amount of rows of data will vary), address, qty, phone number, special instructions etc
Sheet 2 is a pre created delivery note.
I want to be able to do the following:
Press the print button (print button has been added to sheet 2) and sheet 2 will populate various data from cells on sheet 1 to compile a delivery note and print 2 copies. Once printed I want the code to look at the next line to see if there is any data if so, populate the next row of information onto the delivery note and print 2 copies. I want this to repeat all the way down until no more data is found. The print button will print from the default printer.
Someone please help, its been about 8 years since I last used VBA and am seriously struggling?
I have an example of the file which I can either post to this thread or send directly for you to look at.
Thanks in advance.