Good morning, all.

I am working with Range.AdvancedFilter to get a unique set of values FROM a listObject and then insert them INTO another list object.

The destination listObject is created using VBA and is initially only a header and one row below that.

I can use the code below to get a unique set of values FROM Categories[Agency] but when i copy them TO totalPaidToAgency[Agency] only the first element in the range is inserted into totalPaidToAgency. The others are there but are not part of totalPaidToAgency. How can I use AdvancedFilter with xlFilterCopy to insert all of the elements into totalPaidToAgency?

Thank you in advance!

Dim filterRange As Variant

filterRange = Range("Categories[Agency]").AdvancedFilter(xlFilterCopy, , Range("totalPaidToAgency[Agency]"), True)