Posts by falak

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

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

    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

    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

    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

    So i basically want to get PO matched from the file browse from computer and copied in a way that wherever PO "9207116092" in C4 of file POD is mentioned in Masterfile ColumG "PO" (like we dont have to right "9207116092" again and again just onetime is enough) and the POD ColumnD from file "POD" is copied to all the rows in CoulmnF(POD) in file "Mastefile" having the PO number as "9207116092"


    Note: Use POD macro to upload POD file

    So i basically want to get PO matched from the file browse from computer and copied in a way that wherever PO "9207116092" in C4 of file POD is mentioned in Masterfile ColumG "PO" (like we dont have to right "9207116092" again and again just onetime is enough and it paste the POD to all the rows having a PO "9207116092", it should paste the POD date (3rd Jan for this case ) there which is mentioned in D in file POD and ColumnF in Masterfile


    NOTE: use the macro Upload POD to upload from the file "POD"

    @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


    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

    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!

    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


    Here

    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

    Try:

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

    WORKED THANKYOU!!!