Automatically multiply a value

[Frantic]

Hello

I want to be able to enter a value into a cell (within a specified range if necessary) and have it automatically multiply by a set value and overwrite the original entry with the result so making it all happen within one cell.

Is this possible?

Thanks
F

 

[sicahjes]

Hi All,

I know that I am reviving an old thread, but I thought it better to do that, than create a new one - given that my question is based on advice from this thread.

I am attempting to use the code provided here, but on multiple columns with varying values for the multiplication to be based on. When I attempt to do this (in Mac 2011) random things keep happening. I'll just outline what I've been doing, and hopefully someone can see my error:

1. Go to editor
2. select the worksheet by double clicking
3. Paste the code provided, and adjust it (per the info pasted below).
4. Click the play button to run
5. Save it
6. Open editor
7. Modify code for next set of columns
8. Rename
9. Create
10. Rinse and repeat

Mostly, when I do this, each new creation wipes the previous Macro. When I go into Macros and select run, it wipes it.
Sometimes, only the first column will work, I've had to recreate the files completely and start from scratch.

I'm new to this, so I know I'm doing something wrong... I'm just not too sure what.

Here is the info I'm trying to control:

Const WS_RANGE As String = "C11:C56, J11:J56, Q11:Q56" '<== change to suit
Const SET_VALUE As Long = 181 '<== change to suit


Const WS_RANGE As String = "D11:D56, K11:K56, R11:R56" '<== change to suit
Const SET_VALUE As Double = 129.64 '<== change to suit



Const WS_RANGE As String = "E11:E56, L11:L56, S11:S56" '<== change to suit
Const SET_VALUE As Double = 86.42 '<== change to suit


Const WS_RANGE As String = "F11:F56, M11:M56, T11:T56" '<== change to suit
Const SET_VALUE As Double = 43.21 '<== change to suit

Thanks in advance

 

[Flintman]

Where and how would I set another range and multiply it by a different value. I have 3 ranges to multiply by 108.34, 1 by 136.5, one by 173.33, and a last one by 69.