Adjusting entire column of formulas by adding additional cell reference

Hi everybody,

I would like to ask you, whether you would know if there is any way how to adjust formulas in a selected range (e.g. entire column).

I've got sheet of a range approximately 800 x 50 cells and I would like to multiply formula in each of the cells by flags (located in another sheet). So, something like this operation:

instead of
=L228
=L229
.
.
.

I would like to have
='Flags quarterly'!L27*L228
='Flags quarterly'!L27*L229
.
.
.
.

Thanks a lot for any advice!

Hi
I suppose you need VBA
Use this code in a module VBA

Please Login or Register  to view this content.

Notes:
You can't undo so you must save your work before use
Pay attention to string you want add. For example $L$7* when applied to a cell that has a formula =A1+B1 gives you =$L$7*A1+B1
To use you must select all cells you want change
In VBA immediate window write Change_Formulas and press ENTER
In the input box enter the string to add to formula without the sign equal

I hope this helps you