Hi,
I have a few vehicle at my work which people take at random times. I am wondering is it possible to have a spreadsheet where the sheet shows
Which car (drop down window)
Person taking car
Reason for taking car
Time Out
Expected Return
Time In
These would have a field box next each question.
After the info is entered they hit a 'GO' button or such. It then updates that info to a second sheet or multiple sheets that correspond to the car rego.
Once they hit go they question fields empty and the next person can enter the details?
Preferably i would like to do this with formulas not VBA as I dont know VBA.
I have a few vehicle at my work which people take at random times. I am wondering is it possible to have a spreadsheet where the sheet shows
Which car (drop down window)
Person taking car
Reason for taking car
Time Out
Expected Return
Time In
These would have a field box next each question.
After the info is entered they hit a 'GO' button or such. It then updates that info to a second sheet or multiple sheets that correspond to the car rego.
Once they hit go they question fields empty and the next person can enter the details?
Preferably i would like to do this with formulas not VBA as I dont know VBA.