LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatic total of selected cells MarlboroughT&C New Users to Excel 6 January 15th 09 02:06 AM
automatic numbering of cells in excel George Excel Discussion (Misc queries) 7 March 7th 07 06:46 PM
Automatic row insertion PURVIANCE Excel Discussion (Misc queries) 1 December 6th 06 08:59 PM
Automatic Date Insertion? tristatefab Excel Worksheet Functions 2 March 20th 06 08:36 PM
Auto insertion of date and time MC[_4_] Excel Programming 8 July 21st 04 03:54 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"