Web Query
 

Hi,

I have data in 10 columns.

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

I need to validate, entered routing number is valid or not.
For that I will copy the routing number and I will check in web site.

To minimize the time any macro can be assigned to validate whether the
mentioned routing
number is valid or not ?

waiting for solutions.

Web Query
 

On May 17, 4:47*pm, muddan madhu wrote:
Hi,

I have data in 10 columns.

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

I need to validate, entered routing number is valid or not.
For that I will copy the routing number and I will check in web site.

To minimize the time any macro can be assigned to validate whether the
mentioned routing
number is valid or not ?

waiting for solutions.

Hi,
You can loop all the nos you want to validate and feed the same to web
query and perse the results as required.

Regards,
Madiya