Web Query

  • Thread starter Thread starter muddan madhu
  • Start date Start date
M

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.
 
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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Query 4
Iterate rows, add like values - an easier way? 1
Get/Find criteria and copy sum 2
Find and loop help-multiple columns 3
Auto Copy Data from one worksheet to another 1
Storing VBA Code In a Cell to Use real Time 2
Data Validation based on first, second or third data validation li 2
Lose relative connection in formula on sort 2

Back
Top