Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query with cell reference.
Why not have your query come in on one sheet, then use formulas (like
Vlookup) on your "form" sheet to populate the appropriate locations. =if(b2="","",Vlookup(B2,Table,2,False)) -- Regards, Tom Ogilvy "G. Wolfe" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i reference a cell with url for web query import? | Excel Worksheet Functions | |||
Query about Last Cell reference. | Excel Discussion (Misc queries) | |||
web query with cells reference | Excel Programming | |||
Web Query/Cell Reference | Excel Programming | |||
Microsoft Query - how to reference a cell value in a filter | Excel Programming |