Hi everyone,
I've got a problem which I feel is going to be easy to solve, but I think I'm lacking that crucial nugget of knowledge to achieve it! I've tried a couple of similar things in VBA that I've picked up on the web, but I just cant get it to work.
What I'd like to do to the attached spreadsheet (sample attached) is where the number '1' is displayed in 'H20' for that to display a different number on each printed copy.
It needs to print numbers 1-22, then 29-42, then 51-54.
Ideally, I'd also like to add a 'Print' button to the spreadsheet so that just pressing that would automate the whole process, but one step at a time!
Thanks for your time!
JB
I've got a problem which I feel is going to be easy to solve, but I think I'm lacking that crucial nugget of knowledge to achieve it! I've tried a couple of similar things in VBA that I've picked up on the web, but I just cant get it to work.
What I'd like to do to the attached spreadsheet (sample attached) is where the number '1' is displayed in 'H20' for that to display a different number on each printed copy.
It needs to print numbers 1-22, then 29-42, then 51-54.
Ideally, I'd also like to add a 'Print' button to the spreadsheet so that just pressing that would automate the whole process, but one step at a time!
Thanks for your time!
JB