K. Georgiadis
07-02-2005, 05:26 PM
I know how to use Excel's built in Advanced Filtering to sort for unique records. I was wondering if there is a VBA procedure for accomplishing this. Say that the data range is A2:K126, with row A2 containing the headings and each subsequent row constituring a record. The objective would be to select the unique records out of the data range and display them in a new worksheet "Unique Records."
You might say that this post is a matter of curiosity rather than an urgent need.
PS: Ooops! I forgot that the filtered data can only be copied to the active worksheet. Also, I think that I can answer my own question by performing the advanced filtering and recording the steps.
You might say that this post is a matter of curiosity rather than an urgent need.
PS: Ooops! I forgot that the filtered data can only be copied to the active worksheet. Also, I think that I can answer my own question by performing the advanced filtering and recording the steps.