Hi Guys,
I will do my best at explaining my situation, hopefully it is possible and someone knows how.
We have a Workbook which is used to log Calls done over the Radio for Security guards. Just to have a copy of where they have been at what time.
Now at the moment they have to say their Security Licence over the radio to Identify who they are.
Now I had an idea, if each guard had a pass-phrase sort of thing.
E.G. John Blow = JG467
He states his pass-phrase of the radio and whoever is monitoring enters the Pass-Phrase into the excel.
Once the the Pass-Phrase has been entered, in a cell next to it, it comes up with the guards name assigned with that Phrase.
Would something like this be possible.
I know a database is more suitable, but I wanted to give this idea a try
I will do my best at explaining my situation, hopefully it is possible and someone knows how.
We have a Workbook which is used to log Calls done over the Radio for Security guards. Just to have a copy of where they have been at what time.
Now at the moment they have to say their Security Licence over the radio to Identify who they are.
Now I had an idea, if each guard had a pass-phrase sort of thing.
E.G. John Blow = JG467
He states his pass-phrase of the radio and whoever is monitoring enters the Pass-Phrase into the excel.
Once the the Pass-Phrase has been entered, in a cell next to it, it comes up with the guards name assigned with that Phrase.
Would something like this be possible.
I know a database is more suitable, but I wanted to give this idea a try