View Single Post
  #2   Report Post  
L. Howard Kittle
 
Posts: n/a
Default

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?