Hello, please find our next project attached. There is a copy of every invoice or packing list which we have produced since 14/03/12. We need all of the products counted together so we know how many units of each product have been sold. Each product has a different name and different size. For example the Men's Aspire Wetsuit there is size S, SM, M, MT, ML, L, XL.
We need the total quantity of each product entered into one single spreadsheet. We just need a simple total for each product in each size.
There are 197 invoices in total which need to be combined into one spreadsheet.
In some folders there is both a Packing List and an Invoice. PLEASE only note down the product totals from one of these documents because they are the same and if you enter both the overall total will be wrong and too high. You can use the data from any of the documents in the folder.
Please let me know if you have any questions.
The file with all of the invoices in is too large to upload so please tell me the best way to send it to you?