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

Re: Automatic Numbering of Job Card, Insertion of Date and Time into selected Cells

hi, thanks for reply. Ideally I would like one copy on a server that can be accessed by all and used to generate the paper trail. The idea is that once printed the doc is attached to a machine for the workshop, work done filled in an invoiced. Once all this is done the job card is filed. Thanks, Ciaron.

Re: Automatic Numbering of Job Card, Insertion of Date and Time into selected Cells

hi, pls see attached. Need the numbering in the cell with xxxxxx thanks, Ciaron

Re: Automatic Numbering of Job Card, Insertion of Date and Time into selected Cells

got it mate, thanks very much, works the bomb. Cheers Ciaron