Dear Let Me See :-)

Sorry, your problem is not clear... Your example does not have same item on
both sheets. How will you treat this case?

Also how do you order the item names?

What you should do i have a helper column which gives the sequence number
within a group. Once you have that it is easy to consolidate, merger, sort
etc...

To me it looks like that you want to merge the two sheets and if the same
item is on both sheets have the item no. only once by eliminating the
quantity with only one of them....

"Lemmesee" wrote:

I have 2 sheets with Item Numbers, Quantities, And Descritpions.
The Description of the Item May be 1 row or Multiple rows.

On a third sheet, I need to consolidate the list from "sheet 1" and "Sheet
2" elimating the Item Number and Quantity if the Description is more than 1
Line.

Note:
On the First 2 Sheets I have a formula for the Item Number, similar to:
=IF(B2="","",MAX($A$2:A10)+1) , So that once a QNTY is entered in Column "B"
it gives a new Item Number. Allowing "Blank" rows and/or "Multi-Line
Descriptions".

I am not sure if you can make sense of this example below, But If you can I
would appreciate it.
Thanks in advance.


"Sheet 1"
A B C
1 Item# QNTY Description
2 1 10 Apple
3 Red
4
5 2 11 Apple
6 Green
7
8
9
10 3 1 Orange

"Sheet 2"
A B C
1 Item# QNTY Description
2 4 2 Orange
3 Rotten
4
5 5 1 Banana

€œSheet 3€�
A B C
1 Item# QNTY Description
2 1 10 Apple
3 Red
4 2 11 Apple
5 Green
6 3 1 Orange
7 4 2 Orange
8 Rotten
9 5 1 Banana