Trouble with For Loop

Probably easier to use Advanced Filter | Copy.

Post a sample workbook, so I can show you an example on your data structure...

You will actually need a variable for the city name and then your code needs to dynamically create a new sheet if it does not exist yet and paste the record onto that sheet. After the macro has run, you should end up with a new sheet for each city in your list.
Your code is only copying two columns, yet your columns are up to the "O" column. Is this intended?

If you can post a sample file with some dummy data representing your data structure, we can help you with a macro.

Doesn't help much - it bears no resemblance to the requirement you posted...

Try again: Show us your actual data structure, and what your required outcome looks like. Mock it up manually if necessary. Include header row(s), include the relevant source AND target worksheets. By all means, sanitise any sensitive data, but make sure what is left is enough to work with, and matches what you are describing. There's no 'Griffin' in your attachment, there's no "Telemetry" sheet... etc.

You know in your head what you mean. We only have your words and your workbook to go on...

Hi,

Try this code...
Workbook with code attached below.

Please Login or Register  to view this content.

Hi EverGreen,

I forgot to mention that for this to run effectively you need to activate the Microsoft Scripting Runtime Library under the VBA Reference Library list.

See the attached image and follow these steps to have the macro run properly again.

1. From the workbook where you run the macro, press ALT+F11
2. In the VBA editor which activated, click on the Tools Menu
3. Select References
4. In the dialog, scroll down to Microsoft Scripting Runtime, and tick the check box
5. Select OK

The macro will now run properly again.