open the time formula automaticly in B1 after tabbing from A1
Thanks Roger & Bob
"swede" wrote:
I have made a hospital porter tracking spreasheet. I have drop down colomns
with, where the porter is going (from and to) and the porter who is doing the
job and colomns with the now formula, which I have used validation for them
all. I can type in the data which is in the drop down boxes and tab to the
next cell, but have to use the mouse to click on the time. I can use the
shortcut (alt -arrow-arrow-enter-tab) for the time but is there a way of
opening the time after tabbing from the cell which has the porter in it
(which starts the job) Phew!! I know what I mean but does anybody else! Help
|