Stop linked cells from skipping newly inserted rows I have 4 tabs in the SS. I h

Question

Stop linked cells from skipping newly inserted rows

I have 4 tabs in the SS. I have cells in tabs 2-4 linked to tab 1. If i insert new rows on tab 1 my linked tabs are skipping the new inserted rows.

So...say Tab2 rows 4-200 are linked to Tab1, but when a user adds rows on Tab1, Tab2 just omits the new rows. (Rows are added to Tab1 as SS is used). I need Tab2 to link to Tab1 AND include any new inserted rows. (These 2 tabs do NOT look identical and there is much conditional formating on Tab2)

Hope this was enough info....

Explanation / Answer

You will have to enclose the formulas in INDIRECT function. For ex,

= INDIRECT("TIMECARD!A45")

= INDIRECT("TIMECARD!A46")

= INDIRECT("TIMECARD!A48")

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects