VBA to copy unique range to specific range area

[tantcu]

Hello,

I'm looking for a macro that copy unique data from B40 to the end and paste unique data to rang O40:O57. Please help.

[gjcase]

Try using the macro recorder & see if that gets you what you're after.

[tantcu]

No it copied all duplicate data and can not paste unique record only.

[JOHN H. DAVIS]

Can you provide a sample of your data? It helps to visualize what you are trying to achieve. It sounds like you need a filter.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[tantcu]

Please find my attached. ThanksTest1.xlsx

[AB33]

The copies in to range A8. You need to change it to suit your needs.

[JOHN H. DAVIS]

I'm not sure if this can help you, but if it is OK to sort your data this might help.

Please Login or Register  to view this content.