Extracting data

D

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top