I have a salary chart that I am trying to add 3% increase to the whole grid
K Kate/comp Dec 17, 2006 #1 I have a salary chart that I am trying to add 3% increase to the whole grid
D Dave Peterson Dec 17, 2006 #2 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
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
D Don Guillett Dec 17, 2006 #3 You can change the values by sub upit() for each c in selection c.value=c*1.03 next c end sub
N Niek Otten Dec 17, 2006 #4 In an empty cell, enter 1.03 Edit|Copy Select your data Edit|Paste Special, check Multiply -- Kind regards, Niek Otten Microsoft MVP - Excel |I have a salary chart that I am trying to add 3% increase to the whole grid
In an empty cell, enter 1.03 Edit|Copy Select your data Edit|Paste Special, check Multiply -- Kind regards, Niek Otten Microsoft MVP - Excel |I have a salary chart that I am trying to add 3% increase to the whole grid
