Merging work sheets

[Joe Excel Novice]

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.
--

[BadlySpelledBuoy]

Hi Joe and welcome to the forum.

Have a look at the attached. Is that anywhere near what you need?

BSB

[Joe Excel Novice]

Hi BSB,

Many thanks for the very quick response - it's more than 'anywhere near' - it's on the button!

Again, many thanks.

Joe.
--

[BadlySpelledBuoy]

Happy to help

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

BSB

[Joe Excel Novice]

Right - I give up - how do i close this thread?

JOe.
--

[BadlySpelledBuoy]

Sorry mate, I should have added that detail. My bad.

Select Thread Tools from the menu link above your initial post and mark this thread as SOLVED.

BSB

[Joe Excel Novice]

Sorted - thanks for the heads up