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
 

Whether manually or by VBA, go to the website and copy the list of valid
numbers into a column is the worksheet. Then use VLOOKUP() to determine if
the user-supplied number is in the list.
--
Gary''s Student - gsnu2007h


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

Web Query
 

I prefer VBA


On May 17, 5:07*pm, Gary''s Student
wrote:
Whether manually or by VBA, go to the website and copy the list of valid
numbers into a column is the worksheet. *Then use VLOOKUP() to determine if
the user-supplied number is in the list.
--
Gary''s Student - gsnu2007h



"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.- Hide quoted text -

- Show quoted text -