I want to reduce time at the coal face.

[MACDOB]

Hi folks. I am trying to be a little bit more efficient and I am working on an Excel sheet for booking in transport and suppliers.. I have started the sheet and I want to be able to just click on a cell and the date appears in col A in col. B I want to be able to click on the cell and the actual time appears for the time in, a running clock which stops whne I click on the cell or perhaps I will have to have a button. I will be able to appy this in another col. for time out. Another trick I would like to use is the one which happens when you start to type an e-mail addres and after a few letters a number of contacts appear for you select from. How do they do that?
This is my first post so apologies if I am asking too much. I have never done VB or C++ threfore I will need instruction if it is a macro in how to get it into the worksheet. Thanks in anticipation and have a good day out there

 

[MACDOB]

Hi jameo. Thank You a bundle that will make life a lot easier. How are you on a macro for as soon as I type say two or three characters a quick list of similar characters appears for selection. the same as when you start to type in an email address in explorer. Obviously a list would need to be compiled similar to a contact list and I do have all of that information but haven't compiled it yet. Or would it have to be done in a different programme language. Or is it a step too far. I know that there is a drop down list facility in Excel but I was hoping to be a bit more sophisticated