Can you provide more details? Such as - is each address in one row, but stretched across multiple columns? Is the country field in the same column for all addresses? Can you post an example?
As a side note - adding a filter and copying/pasting (if there is one address per row) is quick and easy IF it's something you aren't going to have to do very often.
(If you click on the "Tips for Posting" link at the top of this page it will take you to a thread that explains add-ins that allow you to add image examples/screenprints to your posts. I just started using MrExcelHTML and LOVE it.)
Yes, I have three thousand names and addresses- there are 18 columns with different text. Address 1- Address 2 City state City Country
So you are saying to sort by country and then copy and paste to the new tab. That makes sense.
i will try. I love macros and formulas that I want to use them all the time and forget the easy steps.