Hi Lucky,
Perhaps using a drop down list. Say you have the bosses name in A1 and a
drop down in A2. Select an employee and using a vlookup, that employee's
personal data is displayed in B2:?2.
Next boss is listed a couple rows below and another drop down list of
his/her reportee's.
I can send you an example of what I'm describing if you wish.
HTH
Regards,
Howard
"Lucky05" wrote in message
...
I would like to acheive a spreadsheet that I can list several people names
on
top and then who reports to them on the bottom, etc.
Similiar setup as you would do for a family tree.
Is there a spreadsheet already format in Exel or Word (like a template)
that
I can use and input my information?
What would be the best way to set up a project like this?
|