ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   link spreadsheet with form (https://www.excelbanter.com/excel-worksheet-functions/7393-link-spreadsheet-form.html)

rocketman

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.

Frank Kabel

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