Posts by Zahid0111

    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

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

    I need a VBA code for a button which when clicked browse for other excel file, search for specific sheet named “Farmer History” in it. In this sheet it looks for A1 complete row and search heading “Crop Area” and copy this column data to main file(where button embedded) in sheet named “Berkhund” at address F3.

    The same to be done for other 2 columns too i.e

    Looks for “Target Qty” in first row at same sheet “Farmer History” and paste in main file sheet “Berkhund” at address R3

    Looks for “Commulative Sold” in first row at same sheet “Farmer History” and paste in main file sheet “Berkhund” at address S13