Excel: Increasing a Number in a Formula?

Microsoft Excel home and student 2010 so...
February 17, 2011 at 08:16:01
Specs: Windows XP
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?

See More: Excel: Increasing a Number in a Formula?

February 17, 2011 at 08:36:30
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!

Report •
Related Solutions

Ask Question