| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
