Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) |