First time user.
Hi everyone. I'm currently writting a key register for a construction company.
The register keeps track of which contractor has which key.
I currently have 3 sheets. One sheet is called key type. I have a table listing the keys in catergories in column format. For instance I have 100 Lockwood keys and 50 Gainsborough keys and each key has a distict number. On the first sheet I have an excel table with the headings: person, company, key type and key number. I have validated the key type column to only show a list of the catergory headers. What I want to validate the the key type to only show the district key number for a particular catergory when the catergory is choosen. For instance when I choose gainsborough on the key type I want only the list validation for the key type in the gainsborough column to show up. Is this possible. Do you guys understand my problem.
Hi everyone. I'm currently writting a key register for a construction company.
The register keeps track of which contractor has which key.
I currently have 3 sheets. One sheet is called key type. I have a table listing the keys in catergories in column format. For instance I have 100 Lockwood keys and 50 Gainsborough keys and each key has a distict number. On the first sheet I have an excel table with the headings: person, company, key type and key number. I have validated the key type column to only show a list of the catergory headers. What I want to validate the the key type to only show the district key number for a particular catergory when the catergory is choosen. For instance when I choose gainsborough on the key type I want only the list validation for the key type in the gainsborough column to show up. Is this possible. Do you guys understand my problem.
