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

Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

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

1 response
Excel make cell flash red
hugrl -
Rjc -

13 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses