Update database with latest values (VBA)

  • Hi All,

    I am sorry for my adolescence by asking something seems to be impossible for me.

    I am stuck up with one of primary requirement for my daily routine work.

    The problem is defined below:

    1) The Invoice database is to be auto updated in Master database by replacing the existing content. For this Invoice number is used as base reference.
    2) The required excel file has been attached in this thread to make it more comprehensible.
    3) To elaborate more:
    a. There is an input sheet which has list of invoices with relevant data.
    b. Adjacently there is a Master database spreadsheet.
    c. Whenever input sheet is updated for the same invoice number, relevant updates should get replaced in the Master database spreadsheet.
    4) I tried a lot in the internet for solution but I failed & as a last resort here I am in this valuable forum which has given solutions back in the past.

    I sincerely urge to come up with a solution.

    Thanks in advance.

    - Billy

Participate now!

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