Forum Discussion
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 ...
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.
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.