dynamic data lookup by cell

O

ohkneebee

I need some code to do a database lookup for each cell in specific cell range
that is not emply (e.g. a2-a250) and return a single record from the database
with a select using the value in that cell in the where clause.

I'm thinking the sql will be something like: "select jobname from jobs where
jobid = " (i don't know how to put in the cell reference, or the vb code
around it)

Can someone help me?
 
J

Jean

We're in the same boat, I am trying to do same thing, I
know it can be done, just can't figure out how to do it.

If you ever get yours to work I'd appreciate knowing how
you did it. Thank you.
Jean
[email protected]
 
Top