Automatic Numbering of Job Card, Insertion of Date and Time into Selected Cells

I

inktec

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top