View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Timbo Timbo is offline
external usenet poster
 
Posts: 19
Default NUMBER SEQUENCE GENERATOR

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