Filters using multiple sheets
I am trying to filter countries and then cities because I have calculations
that are specific to the exact spellings. My raw data is on one sheet, the calculations I do are on another worksheet. A sample of the countries is below. Country City AUSTRALIA ADELAIDE AUSTRALIA BRISBANE AUSTRALIA CAIRNS AUSTRALIA CANBERRA AUSTRALIA DARWIN NORTHERN TERRITORY AUSTRALIA FREMANTLE AUSTRALIA HOBART AUSTRALIA MELBOURNE BELGIUM ANTWERP BELGIUM BRUGGE BELGIUM BRUSSELS BELGIUM DIEGEM BELGIUM GOSSELIES As I said, I would like to filter the country, then the city, otherwise, using Data Validation lists all the cities without reference to the country. Is it possible to filter the country on my calculation sheet and then the city? Scott |
All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com