Multiply All values by a cell
Ken Wright wrote:
And the reason you want to do this via VBA rather than a simple
formula which will update automatically is.......
Assuming you are on sheet1 with your table of data, and your
exchange-rate is in some cell on another sheet. Go select the cell
with the exchange rate in and name it xrate. Now go back to sheet 1,
and in any cell type =xrate. Now copy that cell (Not the contents,
but the cell), select all your data in Cols G to K and do Edit /
Paste Special / Multiply. Each entry in Cols G to K will now be
preceded with an = and end with *(xrate). You change a value in the
xrate cell and it is all automatically updated.
Because i want a button to change the currency into Euros by multiplying by
the value and a button to convert back into dollars my dividing by the
value.
Cheers,
Ben
Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"
|