| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
link spreadsheet with form
I'm trying to create a form that is linked to a spreadsheet. The spreadsheet
shows Part Numbers and Descriptions. I would like to go to the form and only have to enter a Part Number and the Description would auto-populate. I'm using Office XP and Windows XP. Thanx in advance. |
|
#2
|
|||
|
|||
|
Hi
use Data - Validation in combination with VLOOKUP. As starting point: http://www.contextures.com/xlDataVal01.html and http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "rocketman" schrieb im Newsbeitrag ... I'm trying to create a form that is linked to a spreadsheet. The spreadsheet shows Part Numbers and Descriptions. I would like to go to the form and only have to enter a Part Number and the Description would auto-populate. I'm using Office XP and Windows XP. Thanx in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Soucre changes when Spreadsheet opened from with within Outlook | Links and Linking in Excel | |||
| Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Is it possible to link an Excel spreadsheet to a Word document an. | Excel Discussion (Misc queries) | |||
| How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions | |||
Linear Mode
