Simple question envolving VBA
On Sun, 16 May 2004 13:34:11 -0500, chrisdarl
wrote:
Hi, i have two columns. A and B. column A contains the data. column B
doesnt contain anything yet. i want to make a macro so that column a is
searched, and only one value of each duplicate value found is put into
column b. i have shown the origional table and the table that i want
after the macro has been run to try and help explain what i am wanting
to do. Many thanks chris.
IF A1 contains a Title (and not data which might be duplicated further down)
you could use the AdvancedFilter method:
====================
Sub Uniques()
Range("A1:A100").AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Range("B1"), _
Unique:=True
End Sub
====================
--ron
|