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" <Lucky05@discussions.microsoft.com> wrote in message
news:2C4EC557-1E64-4AC8-9094-0A734560CE4B@microsoft.com...
>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 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" <Lucky05@discussions.microsoft.com> wrote in message
> news:2C4EC557-1E64-4AC8-9094-0A734560CE4B@microsoft.com...
> >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?
>
>
>