Invoicing based on product and order number

[MOONDRIFT47]

Hi,

I am trying to develop an invoicing system for my company. Most of our customers will have their invoices formatted a certain way which has been relatively easy to solve, however one customer needs to have their invoices formatted in a special way.

I have a sheet that pulls in a list formatted like this:

Date product order number kilos
07/4/14 48% cream 445600 1000
07/4/14 PHM 445600 1500
07/4/14 PHM 445600 1000
07/4/14 PHM 445600 2000
10/4/14 48% cream 445800 500

What I need it to display is the following:

Date Product order number kilos
07/4/14 48% cream 445600 1000
10/4/14 48% cream 445800 500

07/4/14 PHM 445600 4500


So you can see it is grouping the invoice by both product type and order number but grouping by product. Any help would be greatfully accepted and in advance, thank you.

[MarvinP]

Hi Moondrift,

This seems like you simply need to sort by the second column after sorting by the first. See:
http://www.gcflearnfree.org/excel2010/11.2

If this doesn't help and you really need the blank row between your products then keep replying and perhaps supply a sample workbook.

[MOONDRIFT47]

Thank you Marvin,

I feel it may be a little more complicated than this. I want to make it simple for the staff so they don't have to fiddle around with filters etc. I have used INDEX and MATCH to get the data from another sheet, this means I can't sort on different columns plus I need a total for each order number but splitting the products up.

ATTACH]315124[/ATTACH]

This is only an example of the workbook as the full one is 2mb and too large to upload

[MOONDRIFT47]

the workbook attached has the data on the right pulled from another sheet and I need it displayed as it is on the left, any ideas?