I have a spreadsheet with a long list of countries of the world on the left.
The columns are then made up of different sickness types. Users must access the list to find the country and then, depending on the sickness type, find the rule that apply to that specific illness in that specific country.
They therefore have to scroll up and down a lot and it takes time to make sure they are viewing the correct rule in the correct row for that country.
The requirement is a search type function that will take the user to the cell where the country and the specific sickness type "meet".
I created a dropdown list for the countries and the sickness types by using Data Validation, and I used macros to get to the country successfully, move it up and to change the background colour of the cell so the country's name can stand out.
I however need to go to the cell applicable to the specific sickness type to find the rule for that country. Any suggestions will be welcome!
The columns are then made up of different sickness types. Users must access the list to find the country and then, depending on the sickness type, find the rule that apply to that specific illness in that specific country.
They therefore have to scroll up and down a lot and it takes time to make sure they are viewing the correct rule in the correct row for that country.
The requirement is a search type function that will take the user to the cell where the country and the specific sickness type "meet".
I created a dropdown list for the countries and the sickness types by using Data Validation, and I used macros to get to the country successfully, move it up and to change the background colour of the cell so the country's name can stand out.
I however need to go to the cell applicable to the specific sickness type to find the rule for that country. Any suggestions will be welcome!