I'm creating a query that will bring back demographic information for a group
of people. I have person IDs stored in column A of the sheet i'm using for
the query. The rest of the data will be coming from an external db. Is it
possible to create the query (maybe some kind of parameter query?) that
brings back the demographic information only for those people listed in
column A?

I'd rather not have to manually input those person IDs into the query (e.g.,
IN(prs1, prs2, prs3...) because the sheet will be updated regularly with new
people added to column A.

Is this possible?

thanks
rachael