Setup Automation to copy child rows from one sheet to under specific parent rows in another sheet.
I am working on an inventory project where we have one main inventory sheet and then multiple satellite location inventories. We have four categories of inventory types: Category A, Category B, Category C, and Category D. There are a couple things I want to do here:
- Once the inventory is entered into a satellite location sheet, I have an automation setup to alert me of an added row. Then I have a QA checkbox column. Once the box is checked, I would like for the row to copy to the main inventory sheet under the correct Category parent. So, anything that is a child row the satellite inventory under category A will be copied as a child row under Category A in the main inventory sheet.
- I would like for the location column cells to be automatically referenced from one sheet to another. If a location/status on the satellite inventory is changed, then I would like for that information to be changed in the main inventory. I just don't want to have to create a cell reference for each line if that can be automated.
Thanks in advance for the help!!