macro to insert into a formula

[Guest]

I need to insert an addition to a formula across a worksheet. The cells
already contain a simple formula and I want to make the change without going
into every cell and doing it manually. Can "find/replace" help do this or
do I need a macro?

What is
='4631-00'!D$71 ='4631-00'!e$71 ='4631-00'!f$71

should become
='4631-00'!D$71*c5 ='4631-00'!f$71*c5 ='4631-00'!f$71 *c5


+the 4631-00 is a sheet name and every row refers to a different sheet name
+the insert (*c5) would need to adjust as it goes down the column
(*c5,*c6,*c7,*c8 etc..)

Thanks,


Todd

 

[Niek Otten]

Hi Todd,

If there are no formulas with addresses like a$710, you could find all $71
and replace with $71*c5. use the Look in Formula option.

Try this on a copy of your workbook first!