View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Drew Drew is offline
external usenet poster
 
Posts: 13
Default Filter Access query results based on selected information

I am a newby to VBA, but I could use some help with some code to filter data
imported from Access based on selected information from a cell within Excel.
For example, in cell A1 I have a drop-down list of vendor names, when I
select Acme from this list, I would the queried information (from Access) for
purchases ("Purchase" tab) to be updated with only purchases from Acme (or
what ever vendor I have chosen).

Any thoughts? Thanks!
--
Drew