Tweet
Hi guys,
I want to put together what ;looks like a simple thing. I have a number of tabs in an excel workbook which contain different data. The first tab contains amongst other things, a list of counties in California.
What I would like to do is have a lookup sheet, where a user could selected from a dropdown, the county in CA they live in. Then other fields in the sheet would then populate by a number of vlookups data associated with that county.
What I don't know how to do is to create a dropdown feature which will list all the counties (contained on a separate tab).
Any help on this will be greatly appreciated.
I want to put together what ;looks like a simple thing. I have a number of tabs in an excel workbook which contain different data. The first tab contains amongst other things, a list of counties in California.
What I would like to do is have a lookup sheet, where a user could selected from a dropdown, the county in CA they live in. Then other fields in the sheet would then populate by a number of vlookups data associated with that county.
What I don't know how to do is to create a dropdown feature which will list all the counties (contained on a separate tab).
Any help on this will be greatly appreciated.
Comment