Forum Discussion

looqmaan's avatar
looqmaan
Copper Contributor
Mar 09, 2020

grouping on different sheets

hi

i have 2 sheets, sheet 2 has links to sheet 1, therefore any changes done in sheet 1 will pull over in sheet 2. both sheets are grouped the same way. 

if i insert a row between 7 and 8 on sheet 1, the grouping on sheet 1 will expand, however it does not expand in sheet 2, i need it to expand in sheet 2 as well.

excel
Formulas and Functions

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 09, 2020

    looqmaan 

    If you expand formulas in sheet 2 down it works. I'd suggest to use

    =IF(INDIRECT(ADDRESS(ROW(),COLUMN(),,,"1"))="","",INDIRECT(ADDRESS(ROW(),COLUMN(),,,"1")))

    starting from A1 and drag it to the right and down. Please see in sheet 3 attached.

    • looqmaan's avatar
      looqmaan
      Copper Contributor
      Mar 09, 2020

      Thanks, that helps with the expanding of the formula itself, but the grouping needs to expand as well.

      on sheet 1 the grouping now includes row 9 however in sheet 3 it only goes to row 8.

Resources