mass upadate to multiple formulas on one sheet

Hello all,

I need some help. I have a formula in place on a spreadsheet. from colum B6 to AH6. I need to change the forumla ends in 6. What I would like to do is change the formula from b6,c6 to B7, C7 all at the same time. How can I do that?

What is your formula? You might be able to use Find & Replace (CTRL-H).

Hope this helps.

Pete

this is the formula. I have it in every row and colum so it's changes but the end is always going to be C7 or D7, or E7, I need to change that 7 on in all the rows without affecting the data

='Y:\Reporting\Performance Review Data\Performance Review Data\August 2013 - July 2014\Team and Department break down 2013-2014 score cards\[nov 2013 All.xlsx]Part B'!B7

Well, you will probably have to apply Find & Replace a few times - highlight the columns with the formulae, then CTRL-H, then:

Find what: !B6
Replace with:!B7
Click replace all

Repeat for C, D and E.

Hope this helps.

Pete

Thanks Pete