Web Query

[muddan madhu]

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.

 

[Gary''s Student]

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.

 

[muddan madhu]

I prefer VBA

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 determineif
the user-supplied number is in the list.
--
Gary''s Student - gsnu2007h










- Show quoted text -