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.
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.