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

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