Sorry about this but but I have not given you enough information. The =TODAY() works for a cell and thanks to all for the tips. I have also now posed the question on the Excel site.
Each pilot has a sheet with 30 odd columns going accross to cover all the eventualities of the limitations. Each line is a day (dated in column A)
Daily entry by the pilot is easy in the 5 unprotected columns, these are: start time, end time (split shift), start, End and hours flown.
As they enter data on their sheets this it is transfered to the summary albeit, in the same format but it has to be slightly larger (10 lines) to accommodate 10 pilots.
So at the end of the day or whenever the computer is switched off! Or used to run another application ie the internet, whatever. Then, when the pilot opens the Icon to the spreadsheet; for data entry purposes, I would like it to go to todays date on the spreadsheet. At present this goes to the day that the last data entry was made (this is no big thing but it would be nice if it didn't)
How do I get it to open on todays line so that data can be entered?
I hope that makes it a little clearer.
Many thanks
Last edited by MOSTAFA; 29th January 2008 at 08:16.