Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically populating fields in excel
I have worksheet that has certain information about our manufacturing
operation. I have another worksheet where I would like to extract certain data from the first worksheet based on entering one key piece of data from the first worksheet into the second. The first worksheet contains a list of molds by ID number, and the critical dimensions of these molds. In my production schedule, I would like to input the mold ID number and have certain critical dimensions be automatically populated. -- TS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically populating fields in excel
Hi,
That sounds like a Vlookup to me but to give a precise enter we would need to know how the data are laid out that contain the details of your moulds. Mike "TS" wrote: I have worksheet that has certain information about our manufacturing operation. I have another worksheet where I would like to extract certain data from the first worksheet based on entering one key piece of data from the first worksheet into the second. The first worksheet contains a list of molds by ID number, and the critical dimensions of these molds. In my production schedule, I would like to input the mold ID number and have certain critical dimensions be automatically populated. -- TS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically populating fields in excel
VLOOKUP function could be what you need.
You need a lookup range of at least two columns and a cell for "what" to lookup. Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on value. Note the downloadable sample workbooks. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation selection lists for inputting Agent ID number.. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 12:51:01 -0700, TS wrote: I have worksheet that has certain information about our manufacturing operation. I have another worksheet where I would like to extract certain data from the first worksheet based on entering one key piece of data from the first worksheet into the second. The first worksheet contains a list of molds by ID number, and the critical dimensions of these molds. In my production schedule, I would like to input the mold ID number and have certain critical dimensions be automatically populated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating multiple fields from existing data | Excel Discussion (Misc queries) | |||
Automatically populating a future date and time | Excel Discussion (Misc queries) | |||
Populating sequentialcombo's or fields | Excel Worksheet Functions | |||
Help Automatically Populating A Summary sheet | New Users to Excel | |||
Auto populating fields | Excel Worksheet Functions |