MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Linking multiple values to one name

  Asked By: Dale    Date: Mar 14    Category: MS Office    Views: 701

i am currently trying to design a workbook that stores the names
of people and their current and all their previous positions (can be a
lot) they held.
Currently, the workbook head fielders goes like this
Name | Position | Year | Position (2) | Year etc etc.

Because this information is hard to read and process in the
spreadsheet, I would like a design a form that can show this info(in a
vertical manner) and i would like to seek help in the coding of the
form such that it only shows the positions that this guy held before,
and ignore the blank entries under for eg, position(100). Also
planning to write a form to allow me to view the people that had held
a certain position before, but have no idea what function should i use.



2 Answers Found

Answer #1    Answered By: Corbin Jones     Answered On: Mar 14

Forgive me if I'm misunderstanding what you are trying to do - but I think you
may be overcomplicating things.

I would stick to just three columns: name position  and year. You can then filter
either by name or position, sort by year  to get jobs into order. I realise that
you will be duplicating the name field, but the spreadsheet will be much easier
to deal with than one that covers 200 columns!

Answer #2    Answered By: Taylor Evans     Answered On: Mar 14

I believe your situation requires a
database. I prefer using Access for such a task, and then using Excel as
a reporting tool.

Within Access; I would build an Employee table, then the data table for
all the positions and other information. Use ID fields for each table,
and link the employee ID to each position  held. You can build user forms
to enter the data, and export the information  via VBA to Excel.

The reason I suggest a database tool, such as Access, is once you create
your recordsets, all the queries you require, as per your message, are
easy to create.

Didn't find what you were looking for? Find more on Linking multiple values to one name Or get search suggestion and latest updates.