Automate 2-column Advanced Autofilter?

[vegybrgr]

This is the need: calculate and display unique values across 2 columns of input data automatically and output them to a pair of adjacent columns. This is just finding a way to perform the Advanced Autofilter / Unique Records function to output just those distinct pairs of values to a defined location. I'm not a VBA writer. This needs to happen upon a change in the data in the first two columns, so on an autocalculated basis. Using Excel 2007...

Example:

Col A Col B
Fred 971
Fred 971
Fred 905
Fred 905
Ethel 326
Ethel 326
Ethel 110
Mona 405

So, Optimal Output would be to 2 other columns:

Col C Col D
Fred 971
Fred 905
Ethel 326
Ethel 110
Mona 405

No other solutions within my wee grasp seem to work.
Thanks for any thoughts.
Veg

 

[SkipVought]

Hi,

Data > Filter > Advanced Filter --

Copy to another range
Unique Values

Vola!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vegybrgr]

Thanks--that's exactly the result I'm looking for, but I need it to happen automatically. I should have been clearer: the range of data in the input colums A and B gets updated periodically, and I need the FIlter> Advanced filter with UNique values to automatically recalculate and update what is in the output Range. I can take those steps manually, but this has to execute each time that the data dynamically changes.
Thanks for your reply and suggestion.
V

 

[SkipVought]

Check out the Worksheet_Change event.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}