CODEWITHSUNDEEP
excelformularelation
Mitch
Mitch

Reputation: 27

Excel - Changing all formulas based on row number

Goodmorning!

I would love to to keep it simple. I have some numbers where I have to make a monthly report from.

For example the numbers I would take in the monthly report, are now based in: 

=K54
=N54
=L54
=O54
=M54

Next month the same type of numbers are based in: 

=K55
=N55
=L55
=O55
=M55

So just 1 row under. Is it possible to change all simple formulas at once?

Thanks for your advice!

Upvotes: 0

Views: 642

Answers (1)

Olly
Olly

Reputation: 7891

Select your range of formulas.

Click Home > Editing > Find & Select > Replace...

Replace what: 54

Replace with: 55

Click Replace All

Upvotes: 1

Related Questions