Combining two data sheets into one data sheet only (getting the uniques datas)

**Aramis_P** · 07-28-2009, 11:03 PM

Guys,

How can I combine the 2 excel data in to one excel sheet only, the two data sheets have similar data and i want to get the unique data so it wont duplicate on my new data sheet. Pls. help me how to do it. Thanks.

**teylyn** · 07-28-2009, 11:06 PM

Hmm. How about a little more detail?

**Aramis_P** · 07-28-2009, 11:17 PM

I have 2 different data sheets...and i want it to combine it into one sheet only..

The first data sheet contains DATE, TIME IN, NAMES

1st DATA SHEET
Date Name Time In
06/1/2009 Mac 7:00AM
06/3/2009 Mac 7:00AM

2nd DATA SHEET (contains Name and DATE)
Date Name
06/01/2009 MAc
06/02/2009 MAc

If you notice in 1st data the DATE is not in order so i want to insert the 2nd data sheet into the 1st datasheet, adding the date 06/02/09 so i have a complete date from 1 to 30.

**rasonline** · 07-29-2009, 05:19 AM

Post up an example of your workbook and then somebody can suggest a solution. it will probably be quite tedious to type out and describe a whole solution for this.