In that scenario I would recomend a database query with parameters. You may
find the help on how to create them in MS Query help, and how to input the
parameter in Excel in the Excel file, but basically is editing the SQL code
that the wizard generates in MS Query to add a condition comparing to a ?
sign.

Hope this helps,
Miguel.

"Mraggie" wrote:


I need to do a VLOOKUP from a table in MSAccess. I want to use the same
Access table to provide data to multiple spreadsheets.

For instance, I have a client list that has client name and salesperson
name linked to the client number. I need to pull both the client name
and sales person by the client number in my Excel spreadsheets. The
only place I have this data is in Access. Because the data in the
Access table is live data, I don't want to repeatedly export that data
into a spreadsheet to complete my VLOOKUP.

Can anyone help???


--
Mraggie
------------------------------------------------------------------------
Mraggie's Profile: http://www.excelforum.com/member.php...o&userid=37290
View this thread: http://www.excelforum.com/showthread...hreadid=570039