Can I do this?

[Harvey Waxman]

Sheet has several columns
Column A has duplicates.
Can the rows containing the duplicate cells be moved automatically to a
different sheet and deleted from the source sheet?

I have the duplicate entries showing up in red using conditional formatting to
make manual deletion easier but I thought I'd poll the group first.

Thanks

--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me

 

[TH]

Yes, but as far as I know it will take some VB (macro) code.
It isn't difficult since you obviously have the 1st sheet sorted to see the
dups. Just cycle through the cells and copy dups to a new sheet and then
delete from the original sheet.

TH