View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
G. Wolfe[_2_] G. Wolfe[_2_] is offline
external usenet poster
 
Posts: 2
Default Query with cell reference.

Hopefully this makes sense or maybe it just can't be done.
We have a bad habit around here re-typing about 5 or 6 different fields of
information on every form we use. Most of the forms are in excel. I would
like the user to request a specific record by part number (from Access) and
the other 5 fields come into the excel form into the corresponding cell. For
example; Part Number:B2, Part Name: B3, Mold Number: N3 and so on. Is
this possible??

I have setup my query, but when I import the information it brings in the
requested record all on one row. Also, the titles of each field are imported
too.

Thanks!!
G. Wolfe