Todd:

Searched it, found it, added it, and damned if you're not totally on point;
that add-in is awesome. I intend to make a donation to that person.
Hopefully I'll figure out what kind of donation will allow me to look at the
VBA, so I can adapt to future needs.

Thanks everyone who responded, it is much appreciated.

Complete Newb


wrote in message
ups.com...
Go to Google and type "Duplicate Master" and click on the first link
that appears...when you see a picture of a baby in a Santa's hat
download that plug in...I know this sounds weird but this is truly one
the better duplicate finding programs I have seen for Excel.

Hope that helps!

-Todd



CompleteNewb wrote:
This was a task that I thought I'd be able to do real easy, but am
apparently incapable.

I have a sheet with values everywhere, I mean just EVERYWHERE. No
organization in terms of rows, columns, etc. Just stuff like a value in
A6,
L4, A10, K116, X65, etc. It's a long story, PLEASE don't ask :)

What I'd like to do is just take unique values from every cell on the
sheet
and place them in one specified column. In fact, if it's too difficult,
I
don't need to only get DUPLICATE values, I can just delete duplicates in
the
finished column once everything's there.

Does anyone know how to accomplish this? I tried adapting several
different
macros I have into a kind of "FrankenMacro" thing, but nothing worked.

Any help on this would be GREATLY appreciated, and thanks for taking the
time.