Hello,
I have mad a listbox with data validation in excel 2007. You can choose up to ten city's. For example Miami, New York, Washington DC, Seatle.
Now I want to be able to put data in two columns beneeth the listbox, a column with the amount of sunhours and a column with the amount of rain.
Now How can I adjust the table so that you can see the information of the desired city after you have selected New York for example. I don't want to see the data from the other city's on this sheet or in these columns.
Sunhours is the first sheet of the map
Rain is the second sheet of the map.
The third sheet is reserved for the listbox and the column with information.
Thanks in advance!
Ps I don't want to use VBA for this.
I have mad a listbox with data validation in excel 2007. You can choose up to ten city's. For example Miami, New York, Washington DC, Seatle.
Now I want to be able to put data in two columns beneeth the listbox, a column with the amount of sunhours and a column with the amount of rain.
Now How can I adjust the table so that you can see the information of the desired city after you have selected New York for example. I don't want to see the data from the other city's on this sheet or in these columns.
Sunhours is the first sheet of the map
Rain is the second sheet of the map.
The third sheet is reserved for the listbox and the column with information.
Thanks in advance!
Ps I don't want to use VBA for this.