Automatic Order Number

[Ann Shaw]

Hi anyone who can help me....

I have an order from created in Excel. I was wondering if
it is possible to have this order number increment
automatically everytime it is printed.

Example I may want 10 copies printed to take an order for
a company while out on the road but when they print I want
them to print out with the numbers increment. Printout 1
= order number 000001, printout 2 000002 etc.. Can Excel
generate a number like this...???

Many thanks in advance

Ann

 

[Don Guillett]

Right click on the excel icon just to the left of FILE>view code>left window
select worbook>right window select before print>

sheets("yoursheetname").range("yourrangename")=sheets("yoursheetname").range
("yourrangename")+1

 

[Ann Shaw]

HI Don

I have tried this but type mismatch keeps coming up.
My Sheet name is Sheet1 and my range name is Order A1:E15.

I have typed in the Code Window:

sheets("sheet1").range("order")=sheets("sheet1").range
("order")+1

It does not like this for some reason it is highlighting
the code in yellow?????

Sorry can you enlighten my further????

Thanks again

Ann

 

[Ann Shaw]

Hi Don

Just tried that out again and used the range name for the
order number doh!!!! It works - excellent - can't thank
you enough - brilliant !!!!!

Go raibh mile maith agat (a thousand thank yous) in Irish!!

 

[Ann Shaw]

Hi

I have set up my sheet to automatically number each sheet
before printing. Can this be done if I have 10 copies to
print instead of clicking File Print x 10 times??

Thanks

Ann