The parameters given leavea lot of holes, but if I were to do something like
that I would first make sure that I had a criteria to select the items that
would prevent duplicates. Probably a columhn with an entry date. Then I
would use the date as one of the criteria to fo filter out the records I
wanted. Then I would copy those visible records from the filter to the new
list.


"Joe" wrote in message
...
I have an input range of potentially 200 rows of daily data. I want to
copy
only those records with data and add them to a perpetual range of data for
the year. This year data grows. How do I use a macro using an advanced
filter to extract the records and add them to the other range of data?