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.
0

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses