Excel 2007 : Merging sheets in 2007

[milleroy]

I have 2 marketing lists for my local area. They are in the same workbook as sheet 1 and sheet 2.

I need help to combine them into 1 woorksheet.

The problem I have is that the only common column is Column A (the Company Name) but not the same names but some are duplicates.

Sheet 1 has columns:
Company name ¦ Address 1 ¦ Address 2 ¦ Address 3 ¦ Town ¦ County ¦ Postcode ¦ Contact Title ¦ First name ¦ Surname ¦ Telephone number

Sheet 2 has columns:
Company name ¦ Address ¦ No. of Employees ¦ Postcode ¦ Telephone Number ¦ Type of Business ¦ Contact name

Is it possible to combine them and then look for duplicates and delete them?
I need to keep all information.

I have spent a few hours trying to do this manually and really didn't get anywhere.

You're help would be appreciated.

[royUK]

It will be difficult to do this because of the different layouts. Maybe you could use VLOOKUP to pull the information across.

Is this an Excel 2007 problem?