View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
inktec inktec is offline
external usenet poster
 
Posts: 1
Default Automatic Numbering of Job Card, Insertion of Date and Time into Selected Cells


Hi,

I have created a job card for computer repairs and rather than print
out a whole load, would prefer a system where any of my staff can open
the job card, print it and fill in the details. I however want the
sheet to automatically (number, date and place the time), once printed
the sheet should automatically update the JOB CARD no, thus creating a
unique set of numbers that can be tracked. Is this possible???. Also is
it possible to protect the excel sheet as to restrict staff access from
manipulating the data. I assume read only would do this, but then would
the sheet automatically update the job card no for the next time it is
opened.????

Thanks, Botswana


--
inktec
------------------------------------------------------------------------
inktec's Profile: http://www.excelforum.com/member.php...fo&userid=7415
View this thread: http://www.excelforum.com/showthread...hreadid=487603