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

Assuming you want the unique combinations in a set of columns, it
sounds like a job for
Data Filter Advanced Filter Copy to another location Select the
columns concerned as the source range Unique values only.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Hi,

First try the manual way and then record the steps. Copy each of the seven
columns of 10 rows and paste them below the entries in the first column. So
if your data is in A1:G10. copy B1:B10 and paste it to cell A11. Continue
until all the data is in column A.

Select all the data in column A and choose the command Data, Filter,
Advanced Filter, choose Filter the list in Place. Make sure your range is in
the List range box, don't enter a Criteria range. Select the Unique records
only option and click OK.

Highlight the visible cells of data in column A and choose Copy. Move to
the other sheet and choose Paste.

Move back to the first sheet and highlight the data from A11 down and clear
it.

Record these steps by turning on the macro recorder - Tools, Macro, Record
new macro. When your finished turn the recorded off - Stop recorder.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Srinivasulu Bhattaram" wrote:

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