Tech Support Guy banner
Status
Not open for further replies.

Printing sequential numbers in excel

2K views 2 replies 2 participants last post by  jb623 
#1 ·
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
 

Attachments

#3 ·
Hi Garf,

Thanks for that, it's definitely a step in the right direction!
However, pressing the new print button (I like that!) only prints the current sheet and the changes the counter from 1 to 2 etc. I then have to press the button again for it to print the next one. Is there a way so that it prints the whole lot with just one click?

Thanks again,

JB
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top