| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
simple Macro needed
I have a column of which autosum keeps a rolling count as the figures are entered and put them in a specific cell "G17"
What i need now is a macro that will take the figure in the cell "G17" and multiply it by 0.40 and put the answer in another cell for me "L20" I would like to add figures in the column and watch autosum edit the figure in the first cell G17 "which it does at the moment" BUT also watch the figure multiplied by 0.40 in the other L20 I have had a look but could not find anything that would answer my question. I though that asking people in the know would be a better option. Thanks for the heads up, Ian |
|
#2
|
|||
|
|||
|
I am not quiet sure why you cant just use a function in cell L20
=G17*.4 But since you asked here is a macro to do it. Code:
Sub Macro1()
Range("L20").Value = Range("G17").Value * 0.4
End Sub
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple loop needed please | Excel Discussion (Misc queries) | |||
| Simple formula needed | Excel Discussion (Misc queries) | |||
| Another simple formula needed | Excel Worksheet Functions | |||
| Help needed in a simple task | Excel Discussion (Misc queries) | |||
| simple (i think) UDF debug help needed | Excel Discussion (Misc queries) | |||
Linear Mode
