Hi All,
I need to mirror two spreadsheets exactly including the colors. One thing I need to ensure is that new rows are also added to the second spreadsheet. Here is the formula I currently have, what am I missing?
=IF(OFFSET(Tenants!$A$1,ROW(A2)-1,COLUMN(A2)-1)=0,"",OFFSET(Tenants!$A$1,ROW(A2)-1,COLUMN(A2)-1))
I need to mirror two spreadsheets exactly including the colors. One thing I need to ensure is that new rows are also added to the second spreadsheet. Here is the formula I currently have, what am I missing?
=IF(OFFSET(Tenants!$A$1,ROW(A2)-1,COLUMN(A2)-1)=0,"",OFFSET(Tenants!$A$1,ROW(A2)-1,COLUMN(A2)-1))
