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

  • To clarify:

    You now want the Master file to display only the total quantity in column H for each order number instead of all the data. Is this correct?

    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.

  • To clarify:

    You now want the Master file to display only the total quantity in column H for each order number instead of all the data. Is this correct?

    Yes. I want all the multiple entries as a single entry conditioning that the ColumnH "Order Quantity" should having a summation of all the multiple entries. Thankyou for all the help

  • To clarify:

    You now want the Master file to display only the total quantity in column H for each order number instead of all the data. Is this correct?

    As a single Order Number have multiple has many entries with the same order number, so i want it sort to one having the total order quantity

  • Glad it all worked out and thank you. :)

    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

    Copying of an addition of column is required

    Hope you are doing well. a very small addition is required in this code as mentioned below right now it was matching the Ordernumber in ColumnC in "POD "file with ColumG in "masterfile" and pasting the respective POD in Column F of "Mastefile", I now want it to copy the data in ColumnE titled as "Exceptions" and paste it into ColumnL of masterfile keeping the format same like for matched order number its respective exceptions should be pasted in ColumnL of masterfile from ColumnE in file "POD"


    Code of module POD is atatched for your reference and files are uploaded

    Thankyou for all the help

  • Try:

    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:

    Worked once, the file is getting hanged for some reasons so not sure. Thanks for all the help!

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

Participate now!

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