Matching data in a column and extracting the rows

[Cleric82]

Hi

I have a series of 10 digit numbers in column A, I am trying to extract any rows where the numbers are the same and place then in a separate sheet (sheet2). Can anyone suggest how I can accomplish this using VBA.

Thanks

[sourabhg98]

hello
can you please attach your workbook

[TMS]

You could probably add a helper column and use COUNTIF to check how many you have of each code. Then filter on the helper column for values greater than one. Select the visoble cells and copy them to another sheet.

Record a macro while you undertake the process. And then ask for help to tweak and generalise it

A sample workbook would help to ensure you get what you want rather than what you've described.

Regards, TMS

[jayesh25]

Hello... Not sure if this is what you're trying to achieve?

I've just hard coded as sample for you.. Please test and let me know.

Place in a standard module

Please Login or Register  to view this content.

[Cleric82]

That code is awesome. However it only pulls 1 entry out. How do I get it to pull every matching entry out?

[jayesh25]

Hmm it should pull every matching entry out... Are you saying that you want to pull out the 1st entry as well? the one it's using to compare and remove everything else??

If that's the case then, the below modification should resolve the issue for you!

Please Login or Register  to view this content.