Hi,

First post - hope I've selected the correct forum.

I have a file that contains two separate work sheets with two sets of data. The item/description is the same to both work books.

I'm trying to get the third workbook to provide all the data on the same line using the item/description as the match.

I've tried to attach a sample file but the attach button is not Mac friendly - or is me?

Wooksheet 1

Item stock min max
Shoes 5 0 0
Polos 0 0 0
Coats 6 0 0
Shirts 3 0 0
Trainers 7 2 5
Ties 0 0 0
Belts 0 0 0
Jackets 0 0 0
Socks 0 0 0
Black Shoes 0 0 0

Worksheet 2

Item Value Jan Feb Mar Apr May
Shirts 40 2 2
Ties 16 3 1 1
Belts 8 4 4
Jackets 45 1 1 1
Shoes 55 1 4 2

Worksheet 3

Item stock min max Item Value Jan Feb Mar Apr May
Shoes 5 0 0 Shoes 55 1 4 2
Polos 0 0 0
Coats 6 0 0
Shirts 3 0 0 Shirts 40 2 2
Trainers 7 2 5
Ties 0 0 0 Ties 16 3 1 1
Belts 0 0 0 Belts 8 4 4
Jackets 0 0 0 Jackets 45 1 1 1
Socks 0 0 0
Black Shoes 0 0 0


Looks a mess hope someone can help.

Many thanks.

Joe.
--