| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically populate fields from the source file
Hi Experts I need help...
I have 2 files File 2 - destination table There are few columns common in the 2 files...like IdNumber, Name, Manager, Dept, etc. My question is when IDNumber is entered in the destination file all other common fields should get populate automatically? Please help me this is very urgent... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automatically populate fields from the source file
Assuming IdNumber is the leftmost column of your source table, you could use
VLOOKUP See Excel help and Debra's site for details. http://www.contextures.com/xlFunctions02.html "Mir Khan" wrote: Hi Experts I need help... I have 2 files File 2 - destination table There are few columns common in the 2 files...like IdNumber, Name, Manager, Dept, etc. My question is when IDNumber is entered in the destination file all other common fields should get populate automatically? Please help me this is very urgent... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare 2 spreadsheets and automatically populate fields | Excel Discussion (Misc queries) | |||
| Automatically Populate Fields | Excel Discussion (Misc queries) | |||
| Automatically Populate Fields | Excel Discussion (Misc queries) | |||
| Automatically Populate Fields | Excel Discussion (Misc queries) | |||
| How do pivot table source fields automatically create tabs | Excel Worksheet Functions | |||
Linear Mode
