Comparing two columns and listing differences
 

Hi

In summary, I have two columns (May and April) where the data in each cell
is a string of numbers, mostly all 10-digits long.

The aim was to compare data now (May) to the data from a month ago (April),
in order to work out what data is being queried now that wasn't being
queried one month ago. I hope that makes sense.

Whilst it could be possible to sift through the list and work out what
numbers are new, it would obviously be easier to have a piece of code that
would do it for me. The data I refer to above has been sorted out from a
wider batch of data and refined even further by other code that I use, so it
would make sense to complete the whole thing by means of code.

Anyway, could anyone assist in providing the code that would determine what
numbers exist in the May column that do not exist in the April column and
either:

(a) highlight the new numbers in the May column, or;
(b) copy the new numbers to another column or worksheet/book?

Thank you very much for any help you're able to provide

Thanks

gb

Comparing two columns and listing differences
 

Hi
as a starting point:
http://www.cpearson.com/excel/duplic...tractingCommon
http://www.cpearson.com/excel/duplic...#InOneNotOther

--
Regards
Frank Kabel
Frankfurt, Germany


gb wrote:
Hi

In summary, I have two columns (May and April) where the data in each
cell is a string of numbers, mostly all 10-digits long.

The aim was to compare data now (May) to the data from a month ago
(April), in order to work out what data is being queried now that
wasn't being queried one month ago. I hope that makes sense.

Whilst it could be possible to sift through the list and work out
what
numbers are new, it would obviously be easier to have a piece of code
that would do it for me. The data I refer to above has been sorted
out from a wider batch of data and refined even further by other code
that I use, so it would make sense to complete the whole thing by
means of code.

Anyway, could anyone assist in providing the code that would
determine what numbers exist in the May column that do not exist in
the April column and either:

(a) highlight the new numbers in the May column, or;
(b) copy the new numbers to another column or worksheet/book?

Thank you very much for any help you're able to provide

Thanks

gb

Comparing two columns and listing differences
 

Col A Col B
Last Month Data Current Month Data
(Start on current month data)

Sub Macro1()
Do Until ActiveCell.Value = ""
CurrentMonth = Value(ActiveCell.Value)
PriorMonth = Value(ActiveCell.Offset(0, -1).Value)
If CurrentMonth = PriorMonth Then
ActiveCell.Offset(0, 1).Select
ElseIf CurrentMonth < PriorMonth Then
'New value
Selection.Font.Bold = True
ElseIf CurrentMonth PriorMonth Then
'New value that did not exist in prior month
Selection.Font.Bold = True
End If
Loop
End Sub

Thanks
-----Original Message-----
Hi

In summary, I have two columns (May and April) where the
data in each cell
is a string of numbers, mostly all 10-digits long.

The aim was to compare data now (May) to the data from a
month ago (April),
in order to work out what data is being queried now that
wasn't being
queried one month ago. I hope that makes sense.

Whilst it could be possible to sift through the list and
work out what
numbers are new, it would obviously be easier to have a
piece of code that
would do it for me. The data I refer to above has been
sorted out from a
wider batch of data and refined even further by other
code that I use, so it
would make sense to complete the whole thing by means of
code.

Anyway, could anyone assist in providing the code that
would determine what
numbers exist in the May column that do not exist in the
April column and
either:

(a) highlight the new numbers in the May column, or;
(b) copy the new numbers to another column or
worksheet/book?

Thank you very much for any help you're able to provide

Thanks

gb


.

Comparing two columns and listing differences
 

You're the man, Frank!

The 'InOneNotOther command was just the ticket.

Thanks very much indeed!

gb

"Frank Kabel" wrote in message
...
| Hi
| as a starting point:
| http://www.cpearson.com/excel/duplic...tractingCommon
| http://www.cpearson.com/excel/duplic...#InOneNotOther
|
| --
| Regards
| Frank Kabel
| Frankfurt, Germany
|
|
| gb wrote:
| Hi
|
| In summary, I have two columns (May and April) where the data in each
| cell is a string of numbers, mostly all 10-digits long.
|
| The aim was to compare data now (May) to the data from a month ago
| (April), in order to work out what data is being queried now that
| wasn't being queried one month ago. I hope that makes sense.
|
| Whilst it could be possible to sift through the list and work out
| what
| numbers are new, it would obviously be easier to have a piece of code
| that would do it for me. The data I refer to above has been sorted
| out from a wider batch of data and refined even further by other code
| that I use, so it would make sense to complete the whole thing by
| means of code.
|
| Anyway, could anyone assist in providing the code that would
| determine what numbers exist in the May column that do not exist in
| the April column and either:
|
| (a) highlight the new numbers in the May column, or;
| (b) copy the new numbers to another column or worksheet/book?
|
| Thank you very much for any help you're able to provide
|
| Thanks
|
| gb
|