Hi,
For my work, I regularly have to fill in data to update the system which regulates the locks and alarms for the company I work for. I have to assign permissions to people so they can or cannot enter certain buildings, open doors, set alarms etc. When a new employee has been hired or has left, I open up the systems program, which is not really more than an excel-like scheet with persons and their ID number, info, permissions etc. I have to remove or add that person, or change their permissions. Now the problem is, since this program is really old and outdated, I can't sort the sheet on name or number and there's no search feature included in the program.
I seriously have to manually scan the sheet searching for the name of that person.
It's also not ordered by alphabet and the list consists of around 600 people. I think i don't have to tell you that this is a really frustrating thing to do.
Normally in windows explorer or anything else, you can just type one or more keys and the selection automagically jumps to the first item in the list that starts with the typed characters, unfortunately that doesn't work for this program. But i'm pretty sure there must be a way to kind of ctrl-f in this program, with either a windows feature or a 3rd party app. This would be way way more efficient and would save me a hell of a lot of work. So like the title says, how could I search in this program which itself lacks search features?
For anyone that can help me, i thank you from the bottom of my heart..
For my work, I regularly have to fill in data to update the system which regulates the locks and alarms for the company I work for. I have to assign permissions to people so they can or cannot enter certain buildings, open doors, set alarms etc. When a new employee has been hired or has left, I open up the systems program, which is not really more than an excel-like scheet with persons and their ID number, info, permissions etc. I have to remove or add that person, or change their permissions. Now the problem is, since this program is really old and outdated, I can't sort the sheet on name or number and there's no search feature included in the program.
I seriously have to manually scan the sheet searching for the name of that person.
It's also not ordered by alphabet and the list consists of around 600 people. I think i don't have to tell you that this is a really frustrating thing to do.
Normally in windows explorer or anything else, you can just type one or more keys and the selection automagically jumps to the first item in the list that starts with the typed characters, unfortunately that doesn't work for this program. But i'm pretty sure there must be a way to kind of ctrl-f in this program, with either a windows feature or a 3rd party app. This would be way way more efficient and would save me a hell of a lot of work. So like the title says, how could I search in this program which itself lacks search features?
For anyone that can help me, i thank you from the bottom of my heart..