| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup in Excel/Access
Can I set a Lookup formula in Excel to read data in an access table
using a macro? What I'm after is for the user to put in a reference number in a cell and the clients details to appear in an adjacent cell. I know this is pretty easy to do completely in Excel but all my data appears in Access. I do not want to export the Access data into Excel every time I want to perform this function. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel lookup, like access | Excel Discussion (Misc queries) | |||
| Lookup In Excel from Access Database | Excel Programming | |||
| Lookup in Excel but pulling from Access | Excel Programming | |||
| Lookup from Excel to Access | Excel Programming | |||
| Lookup Access data in Excel | Excel Worksheet Functions | |||
Threaded Mode
