Jim,

I have found a good solution. I have to rewrite using variables, and add
the copy of the prices, but the structure works.

Thanks for your help.

With one set of symbols in column C, and the other in Column F

Sub CompareLists()

Set ListA = Range("C4", "C7")

Set ListB = Range("F4", "F7")

For Each Sym In ListA

If Sym < Cells(Sym.Row, "F") Then

MsgBox "Mismatch on " & Sym

End If

Next Sym

MsgBox "Symbol Lists Match"

End Sub

--
achidsey


"Jim Thomlinson" wrote:

What is the problem with just using a VLookup, CountIf and or the like?
--
HTH...

Jim Thomlinson


"achidsey" wrote:

Jim,

Sorry I wasn't clear.

We are comparing that the Items in D are the same ones as in A.

What I am doing is copying into columns new prices. Providing the tickers
in D match those in A, I will then copy the new prices in E over the old ones
in B.

Thanks, Alan


--
achidsey


"Jim Thomlinson" wrote:

Well I'm lost... What are we comparing. Are we confirming that all of the
itmes in A also exist in D, or are we comparing the price for an item in A
with the price of the corresponding Item in D or ???
--
HTH...

Jim Thomlinson


"achidsey" wrote:


Excel Experts,

What code will compare two lists?

More specifically, my spreadsheet is similar to the following:

A B C D E
1
2 CurSym Price DataSym DataPrice
3 AMD 22 ADM 23
4 HWP 30 HWP 31
5 INTC 21 INTC 22
6 MSFT 27 MSFT 28

If I name Cells A3..A6 with variable CurSyms, and name D3..D6 with variable
DataSyms, how do I ask in my code,

If CurSyms = DataSyms Then ?

Do I compare them cell by cell using a loop, or can I compare the whole list
at once?

Thanks in advance,
Alan







--
achidsey