HeathAN
07-01-2013, 11:58 PM
Hi,
I am trying to work out how to set up a macro (or VBA) in order to print a page and then pull information form the next row down, rinse and repeat.
The first worksheet I have is for data entry (called Enter Discounts) this has a list that must be manually entered. Also next to each line is a checkbox so I can select whether to print it or not. So I need some thing to check the TRUE/FALSE value, update another worksheet called Ticket with the name from the first worksheet, then print out that worksheet only if the value is TRUE (ie checkbox selected).
Then it needs to go to the next line and do the same thing.
Any help would be greatly appreciated.
I am trying to work out how to set up a macro (or VBA) in order to print a page and then pull information form the next row down, rinse and repeat.
The first worksheet I have is for data entry (called Enter Discounts) this has a list that must be manually entered. Also next to each line is a checkbox so I can select whether to print it or not. So I need some thing to check the TRUE/FALSE value, update another worksheet called Ticket with the name from the first worksheet, then print out that worksheet only if the value is TRUE (ie checkbox selected).
Then it needs to go to the next line and do the same thing.
Any help would be greatly appreciated.