How can i do those three steps automatically :Filter data, sort the order, copy & paste to another w

P

PROXY

i have a Sheet "1" it contains four columns "Country", "City", "TEL#" &
"CONTACT PERSON" with hundreds records.

I want to filter the data where it shows "U.K." in the column "Country" and
copy those records to the desired rows in another Sheet "2", where those
records are presented of "City" in ascending order automatically.

Now I have to sort the data by "City" firstly, filter the record by
"Country",
then copy & paste to another worksheet.

I have tried the "Filter" -> "Advanced Filter". I only can get what i want
if i did
this step at last. However, when i edited Sheet "1", anything i amended
didn't
change in Sheet "2" automatically and i have to do "Advanced Filter" again
manually. I am tried of this manual steps as i have to copy and paste many
times to complete the task. Is there any method to solve my problem?
Thanks in advanced.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010: How to display PivotChart Report Filter Lables on the graph 2
Unable to view the complete data in filter 0
New computer, how do i move outlook 365 ENTIRELY? 0
Copy and paste the cell boarder only not the content 3
Automatic unique records filter macro 7
macro to copy columns and paste into another sheet 0
Unique Records Filter 0
Macro to copy portion of each sheet and paste into the first sheet asa picture 1

Top