I Have a workbook with a number of sheets one is Stock with headings
"Item(Number) Category, Stock, On Order, Sold then sizes 7*5, 6*8, 9*6, 12*9,
A3.

I have another sheet which has Item No. Name, Cat,

What I want to have is another sheet with the two previous sheets
amalgamated onto it. Slight problem though. The sheet Stock has a slightly
different number of Items and in a slightly different order than the second
sheet. How can I get round this. I understand that the Item number would be
the identity point between the two sheets but not sure how I can collate the
data so that the right number (Size) goes to the right Item.

Not sure if this made sense, and appreciate any help you can give me.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nevyn" wrote in message
...
I Have a workbook with a number of sheets one is Stock with headings
"Item(Number) Category, Stock, On Order, Sold then sizes 7*5, 6*8, 9*6,
12*9,
A3.

I have another sheet which has Item No. Name, Cat,

What I want to have is another sheet with the two previous sheets
amalgamated onto it. Slight problem though. The sheet Stock has a slightly
different number of Items and in a slightly different order than the
second
sheet. How can I get round this. I understand that the Item number would
be
the identity point between the two sheets but not sure how I can collate
the
data so that the right number (Size) goes to the right Item.

Not sure if this made sense, and appreciate any help you can give me.