Suppose the individual formulas for the row of October (B10 to E10) linking from a worksheet named Smith_John to a master worksheet are: =Smith_John!B10, =Smith_John!C10, =Smith_John!D10, =Smith_John!E10,

And I want to increase all the number 10 by 1 of all the formulas to get the number from the row of November (B11 to E11) from the worksheet Smith_John on the master worksheet and make them:=Smith_John!B11, =Smith_John!C11, =Smith_John!D11, =Smith_John!E11,

How do I do this?

I found out how to do it! "Home" tap, go to "Find", in the "Find What" box, type in "10", click on the "Replace" tap and type in "11". Click the "Replace All" button, then all the "10"s in the formulas will be replaced by the number "11"s!

Simple enough!

Ask Your Question

Weekly Poll