Macro to filter cities

Hi all


I attached an extract from the long list of companies which will be in column A of Sheet 1

Could you please help me with a macro which finds for example, a list of cities for (25067): YEAR. MONTHLY should be ignored. Then place them in a new sheet with the name 25067, so that column A there shows code of the city and B - the name of city, ex

Column A Column B
A70042 Reading
A70074 Newbury
F70061 London
A70035 Manchester

Then the same will be done for Company C which has code 25070.

It will create new Sheet 25070

Column A Column B
B50329 Moscow
C50426 Novosibirsk
F68306 St Peters
H50324 Kiev
K50448 Tallinn
E68248 Vilnus
E68249 Riga

The whole list of companies which cities need to be placed in separate sheets will be in a Sheet 2, for example
25067
25070

Thanks a lot!

companies.xlsx

Hi rafuk73,
try it

Please Login or Register  to view this content.

Hi Nilem!

Thanks a lot for the code!

1) Could you please advise how to show only cities which are in the section with YEAR (MONTH should be ignored) and

2) The list should appear only for companies which are indicated in the Sheet 2?

THanks a lot!

R

then try so

Please Login or Register  to view this content.

Спасибо огромное! Выручил!!!

На здоровье