Run a Query against a Range???
Posted by mobius on September 03, 2001 10:21 PM
How the heck can I run a parameter query against a range of cells, one by one? i.e - cells a1 - a100 contain numbers - I want to test a match for the value of each cell against a database, and return 2 columns of query results to the spreadsheet...
I can run a parameter query OK, but I would have to type in each cell's value individually - there must be a better way!
HHHEEEELLLLPPP!!!!!
Posted by Gyula on September 04, 2001 1:13 AM
You could probably use VLOOKUP.
If you prefer a macro, please provide more details.
Posted by Gyula on September 04, 2001 1:13 AM
You could probably use VLOOKUP.
If you prefer a macro, please provide more details.
