More detail along with url, etc


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"muddan madhu" wrote in message
...
Hi,

I have data in 10 columns.

In a column I have data related to some codes take an example of
routing numbers.(ABA number)
Suppose user provided 10 routing number in a specified column A.

I need to validate,validate means I have to go specific web address
and enter the routing number
provided by the user and I need to check is it a valid or not.

To minimize the time any macro can be assigned to validate whether
the
mentioned routing number is valid or not ? i.e., if I run the macro
copy the routing number
go to web address and check whether it is valid or not.

if its correct as per the web site here in excel file color it the
cell with some color.

Is this possible ?