Is there any way to auto create sub rows/indented rows?

Is there there any way to auto create indented rows on each new row?

For example, I create a new row which has 20 columns of data associated, I then want 4 indented rows underneath the 'mother' row which will have their own data. I know I can just add a new row and then indent it manually, but I'm looking for a way to either automate this or template it so to speak. The 'mother' row will be created from a form.

Example: My 'mother row' could be a general/global customer data and then I would look to have 4 indented rows for Regions i.e. NORAM, LATAM, EMEA & APAC. Each of these indented rows have say 10 columns of their own additional data outside of the initial 20 columns of global/general data, so my sheet is now 30 columns and 5 rows for each customer.

Thanks

Best Answer

Answers