Hope you can help
I have an invoice I need to subtotal using multiple criteria for the purpose of using for customs clearance in the USA
The problem I have is that Ive tried using the built in Grouping and Subtotalling functions however they don’t seem to give me the results I need.
Ideally, I need to the invoice to group by Columns A & B for both Country of Origin and Commodity Codes and with this data, subtotal the units and costs etc.
Ive tried various methods, including some VBA I found on a helpful site, but it does not seem to work.
I have attached the document in question – the Invoice sheet is the actual data with the Subtotal_Example sheet showing what, if possible, is required (or near to). I compiled this manually from the data so apologies if some of the values differ – it is just to highlight the kind of format I am desperate to achieve.
If you could help, I would be very appreciative