| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Source, auto populate rows and columns
In Excel I have in column A employees 1-10, but not in order in rows 1-200,
and then I manually enter their phone number, address, and employee ID beside them in columns B, C, and D respectively. I do similar redundant tasks all over my files. I know which employee has which number, but how can Excel recognize employee Jane is number 10. I was considering the concept of using an Excel file as a data source, but I will have to study implementing it, and it may not be the right way to go. Would it work like refresh stock quotes? I would highlight the employees in column A 1-200, and then fields B, C, and D would auto populate. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Button - Macro to auto-populate data | Excel Programming | |||
| Auto populate from list/source | Excel Worksheet Functions | |||
| Auto populate from list/source | Excel Worksheet Functions | |||
| Help Please - how to link books and auto populate with new data | Excel Programming | |||
| How do I import external data populate rows instead of columns. | Excel Discussion (Misc queries) | |||
Threaded Mode
