macro to insert into a formula

[Todd]

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!

--
Kind regards,

Niek Otten

"Todd" <[email protected]> wrote in message
news:[email protected]...
>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
>
>