Use Excel to build a family tree

Job ID: 31984433

Budget: €8 – €30 EUR

I want to build an excel program that will auto insert a name into a family tree based on who your parent or grandparent is.

Must be very simple to add or change names and able to span at least 10 generations.
If a generation is missing, must be able to add a placeholder such as Cousin, Parent, Granduncle, Uncle, etc, then go to the name that is being added.

I am welcome to hear how you would solve this issue. Must speak fluent English and have examples.