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 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

    Dashboard - Copy.xlsmAnalytical_Report_Pivot (3) (2).xlsmDashboard - Copy.xlsmAnalytical_Report_Pivot (3) (2).xlsm

  • Cross-posted at:…-to-another-workbook.html

    Please take a few minutes to read the Forum rules at this link: Forum Rules

    You should do the same in the other forum.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!