A code for selecting If any cell = then...

[washingtons]

Hello All,

I'm new to visual basic and am wondering if there's anyway I can write a code that will scan to see if any name in a cell is equal to another name in a cell, and if so, take the highest number (located in another column) corresponding to that name. Any help would be much appreciated!

Thanks!
~Shelby

 

[ByteMyzer]

"Cell"? Are you inquiring as to a Microsoft Access issue, or a Microsoft Excel issue?