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

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

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

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

--
Gary''s Student


"G2 in AUS" wrote:

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

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

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

"Gary''s Student" wrote:

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

--
Gary''s Student


"G2 in AUS" wrote:

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