Good morning happy campers,
I come asking for help an interesting project at work.
Sheet (attached) has sample info in A:A, B:B contains formula of what i want to see printed.
Command button (currently empty)
I would like to be able to click the command button (print area set as B1)
An input box open asking me to confirm print qty, then prints after clicking ok
once this has been sent to printer i would then like the code to move the print range down by one cell each time i click the button.
In reality the data in A:A will be around 400-500 entries, and i need to have the formula in B:B as the data will be copy/pasted into A:A from a much bigger file.
The print options and page margins i can get round (not set to A4) but would love some help on the above
Kind regards, galvinpaddy
Bookmarks