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???
Bookmarks