![]() |
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. |
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. |
All times are GMT +1. The time now is 02:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com