How to move data from one sheet to another and place it with the appropriate customer.
Posted on 2012-08-11
I have two spreadsheets, one has a customer name, invoice number, quantity, amount per, and extension. There can be 1+ invoices for each customer. I will call this the detail sheet.
The second spreadsheet has a calculation that may change the amount per charged on the invoices based on the monthly quantity. This I will call the summary sheet.
When this new amount per is calculated it must be put back into the first spreadsheet. I am happy to create a new amount per for each entry, that will allow me to recalculate the total.
The first spreadsheet only has one row for each customer because it is based on the total amount sold to that customer. But the second spreadsheet has each individual invoice so their may be any number of invoices for a customer.
Therefore I need to match the new amount per to each and every invoice for said customer. So how do I move the amount per to each invoice for that customer name.So customer name will be the same on each sheet. The original amount per on the detail sheet will stay the same but a new one will be created for each of the invoices, it should be new amount per.