I'm trying to create a document whereby I can see which products I have sold to which customer.
Attached is a basic version - the Import tab I will paste in data exported from my MRP system so I need to keep the columns in this order - the only three columns I'm interested in are the ones I have part populated already.
I then want the "All products" tab to collate this for me.
I managed to create a formula that added up the product quantity, but couldn't work out how to also have it customer specific.
Any help much appreciated - many thanks in advance.