I need a macro to do the following:

1. I have a spreadsheet with 10 rows and 7 columns (70 cells
totally).

2. These cells will be filled with values (X,Y,Z etc.).

3. I need to take the unique values alone from these cells and copy it
to another sheet in the same workbook.

I've been trying so many options (Data filter, formulas etc). Can any one
please help me out?

seena




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 081029-0, 10/29/2008
Tested on: 10/30/2008 1:12:55 PM
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com