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.