| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database Linked Spreadsheet
I understand how to make a query for myself, but I need to prepare this spreadsheet in such a way that the user can open it, in column A type all of the primary key values they want to see data for, and have it fill in columns B-I with the data from the database about that primary key value. So that they can print it and show it to other managers. How would I go about doing that? Is it possible? -- jwilliamson ------------------------------------------------------------------------ jwilliamson's Profile: http://www.excelforum.com/member.php...o&userid=34493 View this thread: http://www.excelforum.com/showthread...hreadid=542593 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saving and refreshing workbook linked to a SQL database | Excel Discussion (Misc queries) | |||
| Refreshing a linked Access Database | Excel Discussion (Misc queries) | |||
| How can i create a form linked to a database | Excel Discussion (Misc queries) | |||
| Searching a linked database | Excel Discussion (Misc queries) | |||
| PivotTables linked to Access Database | Excel Programming | |||
Threaded Mode
