Hi,
Hope the formatting of this comes out OK.
Typed it up in notepad 1st.

Anyone good at functions where if 1 cell in a row = a value, then the entire
row is displayed onto another sheet
If one of a few row below it also has a cell in the same column with that
value, then the two rows are added up and only one row is displayed in the
initial one. However, if this happens and one of those rows that has this
value has text in an area, then the text is placed below the displayed line.

For example, if on sheet1 I have the following on Sheet1:

Price Length Width Height Weight Locks Hinges Handles Wheels Dividers Extra Info Selected?
Product1Spec1 10 30 20 10 10 1 2 1 4 1
Product1Spec2 20 60 30 20 20 2 2 2 4 2 1
Product1Spec3 30 90 40 30 30 2 3 2 6 3
Product1Upgrade1 5 1
Product1Upgrade2 5 1 1
Product1Upgrade3 10 1 1
Product1Upgrade4 10 1
Product1Upgrade5 15 Brass Locks
Product1Upgrade6 15 Brass Handles
Product1Upgrade7 20 Brass Hinges No Extras 1

And on Sheet2 I have:

Product2Spec1 10 30 20 10 10 1 2 1 4 1
Product2Spec2 20 60 30 20 20 2 2 2 4 2
Product2Spec3 30 90 40 30 30 2 3 2 6 3 1
Product2Upgrade1 5 1 1
Product2Upgrade2 5 1 1
Product2Upgrade3 10 1 1
Product2Upgrade4 10 1
Product2Upgrade5 15 Brass Locks 1
Product2Upgrade6 15 Brass Handles 1
Product2Upgrade7 20 Brass Hinges 1


On Sheet3 I would like to have automatically displayed:


Product1Spec2 35 60 30 20 20 2 3 3 4 2


Product2Spec3 70 90 40 30 30 3 4 3 6 3
Brass Locks
Brass Handles
Brass Hinges

Eventually this will have loads of these blocks of items and upgrades etc,
with the final page being a kind of order summary page without listing what
is not being ordered.

Hope this makes sense

Any help really appreciated.