Is there a function by which we can paste data below existing data from another workbook

  • Try:

    In your Master file insert "IFCR" in cell I3 before running the macro.

    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.

  • Try:

    In your Master file insert "IFCR" in cell I3 before running the macro.

    WORKED THANKYOU!!!

  • Mumps

    Tried everything but all in vain since hours!

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

    -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 have to extract data from file purchase this time and get the POD dates respectively with their matched PO values already in Masterfile


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


  • Will the "Purchase" file already be open or does the macro have to open it? I assume that the first macro I suggested is working properly to copy the data from the "otc" file. Do you want to extract the data from the "Purchase" file using a new macro perhaps by clicking another button?

    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.

  • Yes, i want another button (a new macro) , for example named as "Upload POD Data" the way same i was uploading previously which you suggested, this time i want it to match the data like for instance:

    copying data from Purchase file, as an example PO number "3" so it should search in Masterfile and paste the POD date in COlumnE ("7th Jan") for this example, in the row where PO number "3" is located or Found i.e in E6


    its like updating the masterfile with Purchase of Order Dates (POD) with their respective PurchaseORder (PO) numbers.


    Thankyou for all the efforts!

  • Create your new button in the Master workbook and assign this macro to it:

    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.

  • Mumps

    Worked!!! but i am eventually putting an IF condition to calculate a function in a completely new column having no data before or after uploading that now showing an error. This function was working when i was filling POD data (ColumnE) manually.

    Basically what i want to do is as soon as POD is uploaded, OTIC should be calculated automatically for all the rows having data in ColumnJ which has a condition that

    ColumnI= If

    D4=E4 then I4*1

    else I4*0

  • The dates in column K of the Purchase file and in columns C and D of the Master file are showing the year 1900 instead of 2020. Before running this macro, you will have to fix that problem by re-entering those dates so that they show the year 2020.

    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.

  • My pleasure. :)

    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.

  • @Mumps

    As you helped for the same thing before kindly look into the files attached again

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

    -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 "Order number" so while pasting it should be pasted into the respective row where that "Order number" in the master file is location

    -As for example In Masterfile C5 has Order number of "9207116092" so when uploading the document having Proof data occurs the value mentioned in Order number of "9207116092" in file Purchase should be paste corresponding row5 in Proof of delivery date" columnF , the value against order number 9207116092 is 3rd Jan

    copying data from Purchase file, as an example Order number "9207116092" so it should search in Masterfile and paste the Proof of delivery date in COlumnG ("3rd Jan") for this example, in the row where Order number ""9207116092"" is located or Found i.e in C5


    I have to extract data from file POD this time and get the POD dates respectively with their matched order number values already in Masterfile


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


  • Every row will have a different order number

    In column C of the POD file, all the order numbers are the same. Column G of the Master file has multiple occurrences of each order number. For example, there are 11 occurrences of order number 9207116092 in both files. The POD file has 8 different dates in column D so I'm not sure which POD dates to use. Please clarify in detail.

    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.

  • Mumps Hi and thankyou for replying. Im stuck long on this, i have attached these two files so what i want to do its to upload data from the file "POD", i want each PO number to be matched with PO number mentioned in Mastrerfile and i want the POD of that respective PO number to be put in respective columnF

    as i have multiple PO numbers of same entries and its a fact that for all same PO numbers the POD doesnot change.

    The Error is it only copies to one cell of that respective PO numbers even thou it should be copuied to all the rows have that same PO nuber

    Example: PO number in columnC in POD file 9207116092 C5 i want it to be matched and pasted to the row where PO number "9207116092" is found in Masterfile, now as the same PO numbers have 3entries i want the POD to be copied to all of these rows having same PO number "9207116092"


    I wish you well, thankyou for all the efforts.


    Note: Use the macro "Upload POD "to upload file POD

  • In column C of the POD file, all the order numbers are the same. Column G of the Master file has multiple occurrences of each order number. For example, there are 11 occurrences of order number 9207116092 in both files. The POD file has 8 different dates in column D so I'm not sure which POD dates to use. Please clarify in detail.

    Also, as POD file is a user entry form if its possible that one entry for a PO number "9207116092" is enough and it automatically paste that POD to all the rows having "9207116092" in masterfile, like it can save human efforts which is my main goal. as for a specific PO number POD will be same regardless of the entries found in masterfile

  • In column C of the POD file, all the order numbers are the same. Column G of the Master file has multiple occurrences of each order number. For example, there are 11 occurrences of order number 9207116092 in both files. The POD file has 8 different dates in column D so I'm not sure which POD dates to use. Please clarify in detail.

    Apologies if this annoys you, kindly look into the file attached now

  • Place this macro in your Master file and run it. When prompted to open a file, open the POD file.

    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.

  • Place this macro in your Master file and run it. When prompted to open a file, open the POD file.

    Worked!! If i want to mend the code in a way that i want if F4 is greater than or equal to E4 then M4*1 else M4*0 so is my code correct?

    Code
    .Range("N4:N" & cRow).Formula = "=if(F4<=E4,M4*1,M4*0)"
  • .Range("N4:N" & cRow).Formula = "=if(F4>=E4,M4*1,M4*0)"

    Change the part in red.

    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.

  • @Mumps

    Hi I am stuck in a slight problem here what i want to do is, in the uploaded file "OTIC" there are number of entries as for example order number in ColumnG "9207116092" have 3-entries. What i want is to sort all the multiple number of entries as a single entry, that when its uploaded using macro "Upload Data" I want it to add all the data of "Order Quantity" in ColumnH and show as a single entry of "9207116092" having the total number of Order Quantities of all the entries, in this case "50,100,250, so instead of three entries i want a single entry of "9207116092" with Order Quantity as 400 for the consider example.

    Code of Macro "Upload Data"

Participate now!

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