software

I have and extracted csv file tha i need be able to write a macro that will
eliminate the duplicate rows with the same customer order number.
Thanks,
G2

Use Advanced filtering:

Pull-down:
Data gt; Filter gt; Advanced Filter…

Click copy to another location
Click List range, clear it, and highlight your table
Clear Criteria range or leave it blank
Click Copy to and select an un-used area in the worksheet
Click unique records only

--
Gary''s Studentquot;G2 in AUSquot; wrote:

gt; I have and extracted csv file tha i need be able to write a macro that will
gt; eliminate the duplicate rows with the same customer order number.
gt; Thanks,
gt; G2

Bingo! Thanks so much, haven't had the occassion to use the Advanced
filtering until today. Powerful stuff
I'm good to go for now

quot;Gary''s Studentquot; wrote:

gt; Use Advanced filtering:
gt;
gt; Pull-down:
gt; Data gt; Filter gt; Advanced Filter…
gt;
gt; Click copy to another location
gt; Click List range, clear it, and highlight your table
gt; Clear Criteria range or leave it blank
gt; Click Copy to and select an un-used area in the worksheet
gt; Click unique records only
gt;
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;G2 in AUSquot; wrote:
gt;
gt; gt; I have and extracted csv file tha i need be able to write a macro that will
gt; gt; eliminate the duplicate rows with the same customer order number.
gt; gt; Thanks,
gt; gt; G2