Hi,

I am trying to create a works requisition in Excel for our staff to use on
the pc and email to me so to make the progress a bit faster than snail mail.

what I need to do is have a 6 digit number starting at 400000 on the top
left hand corner of the page, that will go up by 1 digit each time the page
is opened untill it reaches 500000. so each job reported at the hospital will
have a different work requisition number, so there wont be any duplicates in
the program i am using when trying to get feedback or reports.

I also would love it if you could tell me step by step instructions on where
to insert these codes, as i do not have a clue where to put it. I have messed
around and tried but am getting know where also I would love to know how to
do this anyway?

thank you

Tim

Hi,

The best methods are described here.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Mike

"Timbo" wrote:

Hi,

I am trying to create a works requisition in Excel for our staff to use on
the pc and email to me so to make the progress a bit faster than snail mail.

what I need to do is have a 6 digit number starting at 400000 on the top
left hand corner of the page, that will go up by 1 digit each time the page
is opened untill it reaches 500000. so each job reported at the hospital will
have a different work requisition number, so there wont be any duplicates in
the program i am using when trying to get feedback or reports.

I also would love it if you could tell me step by step instructions on where
to insert these codes, as i do not have a clue where to put it. I have messed
around and tried but am getting know where also I would love to know how to
do this anyway?

thank you

Tim