Previous Topic Next Topic

Macro help

Closed
Jess - Jan 7, 2011 at 03:05 PM
rizvisa1 Posts 4478 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 response

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

Similar discussions

How to create a macro to copy and paste
johncarr1973 -
ac3mark -

3 responses
How to modify the macro code for new structure of table
jpppol -
TrowaD -

9 responses
Convert data with rows into columns
pooja.bs -
TrowaD -

2 responses
VBA code to create Pivot Table
sarisri7 -
ac3mark -

1 response