Increase a currency grid values by 3%
 

I have a salary chart that I am trying to add 3% increase to the whole grid

Increase a currency grid values by 3%
 

put 1.03 in an empty cell
select that cell
edit|copy

Select the range to fix
edit|Paste special|Check multiply

Clean up that "helper" cell

Kate/comp wrote:

I have a salary chart that I am trying to add 3% increase to the whole grid

--

Dave Peterson

Increase a currency grid values by 3%
 

You can change the values by
sub upit()
for each c in selection
c.value=c*1.03
next c
end sub
--
Don Guillett
SalesAid Software

"Kate/comp" wrote in message
...
I have a salary chart that I am trying to add 3% increase to the whole grid

Increase a currency grid values by 3%
 

In an empty cell, enter 1.03
Edit|Copy
Select your data
Edit|Paste Special, check Multiply

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kate/comp" wrote in message ...
|I have a salary chart that I am trying to add 3% increase to the whole grid