Extracting data

[debinnyc]

Hope you can help me.

I have data from two months.
June & July.

I have already reported June's and don't want to report the same data in
July.

How can I extract only the "new" information?

Data1 Data2
a a
b c
d d
e e
f g
h h

The new spreadsheet (column, whatever) would yield:

Data3
b
c
f
g

 

[Luke M]

See site for ways to generate a unique list of data:

http://www.cpearson.com/excel/ListFunctions.aspx

About half way down, section titles "Extracting Elements From One List Not
On Another List"

 

[Don Guillett]

One way
Sub nodupcol()
r = 2
mc = 4 'col D
For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row
If Cells(i, mc) <> Cells(i, mc + 1) Then
Cells(r, mc + 2) = Cells(i, mc)
r = r + 1
Cells(r, mc + 2) = Cells(i, mc + 1)
r = r + 1
End If
Next
End Sub