Conditional Copy Data from One sheet to another workbook

I need to copy data from one sheet to another by following these conditions:
1) User should select/browse for a file, from the opened file, it copies data from column A to Column D from sheet1
2) Column A has unique numbers while column C & D has duplication, it should ignore duplicate.it copies only unique numbers in Column A and their respective data in column B, C & D
3) It paste the Data in Dashboard file(main file) in sheet RawData at column AH to AK by looking into last used row
Image: as shown in image, it should copy the highlighted data and ignore duplication

I have written below code but it,s not according to my requirement, please help me

Please Login or Register  to view this content.

sample.PNG

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Waiting for Moderator's request to be addressed.

@Pepe Le Mokko
Sorry for posting. I didn't see your post until I had already posted the macro.

ok thank you for guidance...i didnt knew this...next time wont happen. Link is below
https://www.ozgrid.com/forum/index.p...48#post1232048
https://www.mrexcel.com/board/thread.../#post-5447704

Administrative note

Please add links to ALL your cross-posts. there are AT LEAST one other.

(Note: this requirement is not optional. No help to be offered until the links are provided.)

It looks like the OP has complied with the Moderator's request.

In your source file, you have merged cells in column A. You should avoid using merged cells because they almost always create problems for macros. Before running the macro, unmerge the cells in column A and re-save the file.

Please Login or Register  to view this content.

Thankyou @Mumps1: i unmerged as you told me. but i need to copy only the highlighted data as shown in the picture(I got this data after running the macro in output file). Kindly check the attached pictureAttachment 667581

The link to the picture doesn't work. Perhaps attach the file and highlight there.

okay now please check the attachments...yellow highlighted rows are only required please

Have a look at the attached file. I believe that the macro is returning the results you requested.

Try:

Please Login or Register  to view this content.

You are very welcome.

Currently your source file does not have any headers in A1:D1. Insert the headers and re-save and close the file. Then try this macro:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

My pleasure.