------ Register to get rid of these "In Post" ads! ------


Great Idea Jacob!

Thanx!!!

I am really thankful 4 all your help pal! However, can't the same task be
also conducted via a macro?

Thanx again.

--
Best Regards,

Faraz


"Jacob Skaria" wrote:

> Faraz
>
> Why dont you try Advanced Filter option. Suppose you have data in Sheet1;
> and you want the unique list in Sheet2.
>
> 1. Assign a header to your column.
> 2. Activate Sheet2 and access the menu Data>Filter>Autofilter and 'Copy to
> another location'.
> 3. In list range type the range Sheet1!A1:A5000
> 4. In copy to type/select cell A1
> 5. Check 'Unique records only'
> 6. Click OK will give you the unique list in Sheet2.
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Faraz A. Qureshi" wrote:
>
> > Could one devise a macro to copy only uniques from a specific column(s) of
> > the "Selected" sheets to a new sheet? Because copying them all together on a
> > new sheet and then removing the duplicates won't be possible as the entries
> > in all might exceed the total rows of a single sheet.
> >
> > Furthermore, the column of one of sheet might contain the entries already in
> > other sheet copied to the new sheet, the macro could also exclude such codes.
> >
> > Thanx in advance 4 all your help.
> >
> > --
> > Best Regards,
> >
> > Faraz