Good Day, I am a first time poster, and I hope i am doing this right 
I have an excel workbook which contains a separate tab with all the drop-down lists, which is used in the all the other tabs.
My Brain Boggle: I have City, Province in separate columns (in the drop-down list tab), So if I choose a City from the drop-down list, I want excel to automatically fill the Province in the cell next to it.
Can this be done? Any assistance will be appreciated so much. Thank you.
Maggie_12

I have an excel workbook which contains a separate tab with all the drop-down lists, which is used in the all the other tabs.
My Brain Boggle: I have City, Province in separate columns (in the drop-down list tab), So if I choose a City from the drop-down list, I want excel to automatically fill the Province in the cell next to it.
Can this be done? Any assistance will be appreciated so much. Thank you.
Maggie_12