auto copy

  • Thread starter Thread starter PROXY
  • Start date Start date
P

PROXY

i have a Sheet "1" it contains a several column "Country", "City", "C" & "D"
with a hundreds rows.
Now i want to filter the data where it shows "U.K." in column "Country" and
copy to a desired rows in
Sheet "2" automatically. 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 it. Is there any method to solve my problem? Thank
you in advanced.
 
Try Data=>filter=>Autofilter

in the country column select custom from the drodown menu. In the resulting
dialog,

in the left dropdown, select Contains and in the right type in U.K.

then select all the rows and do Edit=>Copy

go to the designated location and do Edit=>Paste

You are correct that filters to not update automatically. You have to apply
them. Autofilter is a little easier in that it updates if you select new
criteria.

Anyway, you can do the above steps manually while you have the macro
recorder turned on an get the basic code you need. You can then alter the
code to make it do what you want.
 
Back
Top