+ Reply to Thread
Results 1 to 3 of 3

How to main family tree details in excel, with hiding some details to show only on click

  1. #1
    Forum Contributor
    Join Date
    07-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    141

    How to main family tree details in excel, with hiding some details to show only on click

    Hi,
    I want to maintain family tree of my family and relatives. These details , i want in excel format, and i want only a family details could be viewed when opening the main menu of excel. But if user click, the member in any cell, then that would be redirecting to the other details of family members. for eg.

    father, mother
    sons, daughters
    If i click a sons name, his family details to be shown, like son, his wift, his family members could be viewed there.
    Like wise, if one clicks daughter, her, her husband and their family members should be redirected.
    But the main excel sheet should not show all in one place.
    Is there any easy way of doing it
    One Family tree might extend to so much excel sheets and i want to have each family members in a form of easy excel references. Please experts

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: How to main family tree details in excel, with hiding some details to show only on cli

    I'm sure there are many templates out there for this already.
    https://www.wikihow.com/Make-a-Family-Tree-on-Excel
    I thought the idea of the family tree is so you see the whole tree in one place. You seem to want to reveal details by drilling up and down.

  3. #3
    Forum Contributor
    Join Date
    07-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    141

    Re: How to main family tree details in excel, with hiding some details to show only on cli

    Hi, Thanks for your reply,
    Ofcourse, some forms i could use at the link. But i need the excel only to show one family , say my family on the main sheet, ie opening page.
    All the other things should be kind of hidden, but should appear on clicking on each members name. For eg, if i click, my name in my family, it should show my sons daughters name etc. is there any idea. I am not strong at vbs or macro.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Filter//paste data to 2 columns (title & details), autofill titles to match details
    By Frankximus3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2016, 03:10 AM
  2. Show Details of all cells at once
    By ExcelDavid in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-18-2016, 03:21 AM
  3. list subfolders and files of main folder with details
    By buerere in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2014, 10:44 AM
  4. [SOLVED] how can i search and copy details of a particular User details in Sheet1
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2014, 02:58 AM
  5. I want vba code to extract details from one sheet to another by button click
    By Raj@Akhil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2012, 05:27 AM
  6. Replies: 0
    Last Post: 08-21-2012, 01:19 AM
  7. [SOLVED] if A3 has a number in, show A1 details in Z1
    By petelomax in forum Excel General
    Replies: 25
    Last Post: 08-10-2012, 09:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1