Chrisjack001
asked on
Updating Excel Spreadsheet
I have an Excel spreadsheet called “Invoices Table Update_Test” that I would like to use column A “InvoiceID” field and Column E “Study” field to update another Excel spreadsheet called “Invoice Detail Subtable_Test”. The field to update in this spreadsheet is column B “InvoiceID” field. We will match each “Study” field column J in “Invoice Detail Subtable_Test” to column E “Study” field in “Invoices Table Update_Test”. Once you match a “Study” copy the corresponding “InvoiceID” in column A and paste in the corresponding cell in column B in the “Invoice Detail Subtable_Test”. Example the for “Study” id “123”, the “InvoiceID” is “16719”. That InvoiceID should be copied from A3 of “Invoices Table Update_Test” and pasted to cell B2 of the “Invoice Detail Subtable_Test”. I want to create a Macro or VBA or code that can go through thousands of records and update till it complete the last row which in this case is 611 . Can you please help me. Attached are the 2 Excel spreadsheets Invoices-Table-Update-Test.xlsx
Invoice-Detail-Subtable-Test.xlsx
Invoice-Detail-Subtable-Test.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much
You are very welcome, family matters are more important, hope all is well! :)
Take care,
Daniel
Take care,
Daniel
ASKER