How do I make some columns on a children's row update to match the parent as parent cell changes?


I have a spreadsheet I was given that has styles listed out as Lots which are product specific and then below are children rows that are listed out as SKUs which are product/color specific. In order to not have to alter the same information on each SKU row, how do I make the SKUs row alter it's information based on what is changed in the parent row. Example: if my parent row is marked in process - all the children rows automatically move to in process as well.