Excel Visual Basic Question

[GeoMark]

I have a phone bill that i have copied over from a pdf.

I have used the text to columns tool to convert it into a usable format, with numbers and charges incurred etc in separate columns.

I am attempting to write some code that will search through the phone bill and highlight the entire row if a number from a list is detected.

It is for highlighting business numbers and charging them back to the company i work for

Any help would be great, as i have limited experience writing code in excel using visual basic

Thanks.

 

[Jon von der Heyden]

Hello GeoMark

What column are your telephone numbers in? And are they as text or as true numbers?

Where is the list of known telephone numbers that each # will be compared to?

 

[Michael M]

Hi GeoMark and welcome to the Board
You don't really need VBA to do this.
Rather than explain the process step by step here...
Have a look at Chandoo's site for a very easy way to do the comparison

http://chandoo.org/wp/2010/07/01/compare-lists-excel-tip/