Extracting data
 

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

Extracting data
 

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"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"debinnyc" wrote:

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

Extracting data
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"debinnyc" wrote in message
...
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