NUMBER SEQUENCE GENERATOR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top