| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link info in one cell to info in several cells in another column (like a database)
Trying to create an excel form for administration of roles and competencies in my department. There are like 50 roles and 150 competencies. Each role is composed of 5-10 competencies. Therefore, I would like to link a role to several competencies (to avoid redundancy). Is that possible to do with Excel or will I need to use a DB? -- hansdiddy ------------------------------------------------------------------------ hansdiddy's Profile: http://www.excelforum.com/member.php...o&userid=31762 View this thread: http://www.excelforum.com/showthread...hreadid=514876 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link info in one cell to info in several cells in another column(like a database)
You can link cells in Excel, but someone may be able to provide specific
advice if you provide more details about your workbook, and data, and what you're trying to link. hansdiddy wrote: Trying to create an excel form for administration of roles and competencies in my department. There are like 50 roles and 150 competencies. Each role is composed of 5-10 competencies. Therefore, I would like to link a role to several competencies (to avoid redundancy). Is that possible to do with Excel or will I need to use a DB? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
