assign child rows from parent row

damon25431

I have multiple parent rows each with over 30 child rows. I would like my "Responsible Party" cell in in each child row to be populated if I assign it in the parent row.

I.e. I would like to select the contact (Responsible Party)in the parent. I would then like for each child row under to automatically be assigned to the responsible party in the parent row. (having to assign each row seems a bit too long.)

Thank you for you help in advance

Jason Anderson

If you put this in the 'Responsible Party' cell for any children and whatever is in that column's 'parent' cell will appear in the children. 

=PARENT()

If you drag a row with the formula from one parent to another it updates.