Need macro to remove duplicate rows in a wksht with same order#

G

G2 in AUS

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
 
G

Gary''s Student

Use Advanced filtering:

Pull-down:
Data > Filter > 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
 
G

G2 in AUS

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
 
Top