Hi Forum,
I have a Worksheet (A) with 50,000 plus rows and the records have been updated.
Headings are Invoice Number, Part Number, Sell Price & Cost Price, Customer, plus the updated column.
This Workbook / Worksheet is copied from another Workbook (B) that downloads from a Database.
The Customer column has only recently been included in the records coming across from B to A.
I need to update Customer to the 49,000 records in A that did not include this column. Easy done except, it will overwrite the updated column.
How can I get the Customer data from B to populate A where Invoice is the same value ?
Thinking of a Loop that finds an Invoice row in A with "" in the Customer cell. Then finds the first record in B matching Invoice number and inputs the Customer data into A.
There will be many rows with the same Invoice Number but they will have the same Customer Name.
Speed is not an issue as this is a once only task.
Appreciate advice on this issue
I have a Worksheet (A) with 50,000 plus rows and the records have been updated.
Headings are Invoice Number, Part Number, Sell Price & Cost Price, Customer, plus the updated column.
This Workbook / Worksheet is copied from another Workbook (B) that downloads from a Database.
The Customer column has only recently been included in the records coming across from B to A.
I need to update Customer to the 49,000 records in A that did not include this column. Easy done except, it will overwrite the updated column.
How can I get the Customer data from B to populate A where Invoice is the same value ?
Thinking of a Loop that finds an Invoice row in A with "" in the Customer cell. Then finds the first record in B matching Invoice number and inputs the Customer data into A.
There will be many rows with the same Invoice Number but they will have the same Customer Name.
Speed is not an issue as this is a once only task.
Appreciate advice on this issue