Macro help

Closed
Jess - Jan 7, 2011 at 03:05 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 9, 2011 at 05:09 PM
Hello,

Is there a Macro available that will allow me to only pull unique data from one worksheet to another? For example, I have a bunch of data, some of it is repetitive, and I only want it to pull unique instances of the data.

185441.00.00.0020.000.000.000
185441.00.00.0001.000.000.000
185441.00.00.0020.000.000.000

As you can see here are three data points. On the new worksheet, I only want the unique points to populate, so there would only be two results. Is this possible?

Thanks,
Jessica

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 9, 2011 at 05:09 PM
if the data is in one column, you can use advance filter.
0