Link to home
Start Free TrialLog in
Avatar of Chrisjack001
Chrisjack001Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of danishani
danishani
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chrisjack001

ASKER

I'm sorry for the late response. I had a family emergency and I have been away from my computer for almost 2 weeks. The solution worked great. Thanks very much
Thank you very much
You are very welcome, family matters are more important, hope all is well! :)

Take care,

Daniel