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

  • Thread starter Thread starter PROXY
  • Start date Start date
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.
 
Back
Top