I have a data entry form in excel where I am collecting parent information. I would like to ask the parents the question "How many children do you have?" and collect child gender, child name and child age. I want to repeat the child gender, child name and child age fields several times based on the input by the user.
Is there a way this can be done?