How do I set up a spreadsheet for a family tree?
 

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?

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?

How do I set up a spreadsheet for a family tree?
 

Hi Howard,

Thanks for the information. I'm not sure how I would use a vlookup or a
drop down as you suggested below. I would really appreciate it if you can
send an example.
Thank you for your help and advice.

Regards,

Lucky (Sophia)


"L. Howard Kittle" wrote:

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?