Automatic Add of Rows Depending on Cell Value

I'm a health insurance agent trying to get our company forms to comply with the new requirements of the ACA. For the first time, the insurers need information about enrolling dependent children. Instead of just the number of them, insurers need DOB and gender too for each child.

We try to keep it simple for our customers so just providing us with a census from which to quote isn't difficult (or, we wouldn't hear from them again). So, rather than produce a spreadsheet with as many as 10 child columns which would be quite wide I'd prefer to have the spreadsheet just insert extra rows when the number of children for a particular enrolling employee is specified on the form and is neither a blank nor a zero nor more than 10.

Here's a sample spreadsheet where the first row was filled in and then the operator typed the number 3 into the number of children cell with the automatic insertion of three rows for the children's information and the other rows being pushed down.

I'd also like it to add the labels Child 1, Child 2, etc.

How would I do this in Excel?

Thanks,

LF

Didn't know about the cool reputation thingie. I'll certainly use it.

Don't know much about VBA so will be a few days before I can learn enough to use the code. But I'll devote the weekend to a book on it, I guess.

Thanks so much.

Best,

David