Merging two excel sheets and deleting duplicate data

**noirx4** · 01-20-2012, 06:26 AM

Morning all,

I have a large excel workbook which has two data dump sheets. In sheet 1 "WS Ref No." is column C and in sheet 2 "WS Ref No." is column A. What i want is someway of copying all of sheet 2's column A (and column B) and then copy any values from sheet 1 which are new (only new values in column C column also copy column D but D can be replicated).

Sheet 1..... Sheet 2...... New Sheet
C ......D .....A...... B...... A......... B
1...... 1...... 1..... 1....... 1......... 1
2 ......1...... 3..... 1....... 2......... 1
3 ......1...... 4..... 2....... 3......... 1
4 ......2...... 6..... 2...... .4......... 2
5 ......2...... 7..... 3....... 5......... 2
...................................6........ 2
...................................7........ 3

So in the above example only number 2 and 5 would be copied from sheet 1 to the new sheet.

Finally is there any way to do this without macros or is a macro needed?

Cheers, stu

**Fotis1991** · 01-20-2012, 06:30 AM

Hi stu and welcome to the forum

You can do this, using formulas.

Would you like to upload a sample workbook??

**noirx4** · 01-20-2012, 06:46 AM

example3.xls

Please see attached

**Fotis1991** · 01-20-2012, 07:15 AM

So let's see if i get your point.

In Sheet3, Column C, put the formula:

=IF(COUNTIF(Sheet3!$A$2:$A$566;Sheet1!C4)=0;Sheet1!C4;"")

Copy down.

Is this, what are you looking for??

**noirx4** · 01-20-2012, 07:20 AM

Yes but ideally i want the values returned in column C added to the bottom of column A in sheet 3 so i have all the worksites in one column

Also the problem is there won't necessarilly be 566 rows everytime it will change every week.

Cheers, stu