Uploading the data and pasting it into specific cell by matching the value in it (Updating Data)

  • Hi!

    What i am trying to code is

    -Uploading the data from browser and pasting it Masterfile attached below by button name "Upload POD"

    - As both the workbooks have a same column name "PO" so while pasting it should be pasted into the respective row where that "PO" in the master file is location

    As for example In Masterfile B5 has PO of "2" so when uploading the document having Proof data occurs the value mentioned in PO of "2" in file Purchase should be paste corresponding row5 in POD columnE , the value against PO number 2 is 3rd Jan

    - I just basically wants to update the data by matching its PO numbers

    Note: Every row will have a different PO, so not really any chances of over-driven data



    for reference here is the code im using to upload data at first place mention in the macro of "UploadData"



    @codeL:


    Masterfile.xlsmpurchase.xlsx