Adrian
What you want to happen cannot be accomplished with functions. A
function can only return a value and only in the cell that holds the
function. A function cannot move things around. Functions can pull data
from somewhere to the cell that holds the function, but you want more that
that. You will need VBA (automation).
The explanation you gave in your post is entirely too much to follow,
particularly by the way your data is rearranged in these messages. I can
take the time to help you with this if you wish. Send me your file or an
example of your file. If you feel your data is proprietary just make up
some data. I need just the data layout and the names of the sheets
Include as much detail explanation as you can about what you have, with
examples, lots of examples, and about what you want to happen (this moves
there, etc). Examples of before and after are very useful. Include the
version of Excel you are using.
My email address is . Remove the "nop" from this
address, HTH Otto
"Adrian" wrote in message
...
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.