Moving Duplicate data to a new sheet

Originally Posted by martindwilson

probably best if you attach your file here ,use the paper clip icon in advanced to upload. it's not a good idea to give URLs to possible dodgy sites. even tho rapid share is prob OK at the moment its not letting any free downloads

done ! thanks, could do with help !

Originally Posted by martindwilson

one way ,helper col on first sheet
or you could just put in b4 =COUNTIF($A$4:A4,A4)=3
drag down
then filter on true and copy paste to another sheet

yh cool, i managed to get that far, is there no where, where it would just move it along or copy the data dupes itself? instead of having to filter and paste?

I dont have the problem doing that as it would take me seconds, however other non-literant computer users will be using it, and the less procress i have the harder to break

Originally Posted by pike

maybe

Please Login or Register  to view this content.

sorry how do I use this?

Originally Posted by pike

all the pros approach/solutions are with excels functions - the are faster and efficent
vba is just if you cant find a suitable excel solution .. if your list are too long functions may be the way to go

but try...

that is perfect ! works like a treat, how do I edit that further? only can click on it.

I would I get that onto another sheet?

Hi,

I Stumbled across this Thread while trying to find a solution to move duplicates to another worksheet, I used the "test" file and it works perfectly for copying duplicates to another sheet, but i have a couple of other changes I need & I cant figure it out anywhere!

Firstly I need to be able to actually move the duplicates in the orignal data to the relevant sheets, with the data in the column next to it (expanding the selection as commonly known in excel) The reason for this is because if i have experted a massive database table, i want to keep the original database ID for each item (which is in the column next to the data that could contain duplicates) that way i can easily delete the duplicates in the database by the ID that's been copied to the relevant worksheet....I know you may be thinking, why don't I just run a Query in Access for this, but I'm a complete novice to access, and I would rather just do it in excel for now!

I have uploaded the Test file with a few changes i made so you can see what i'm trying to do, if someone could help me and make the relevant modifcations to the code to actually "move" not "copy" the numbers (along with the data in the aligning column" that would be brilliant! Thanks so much

David