Holiday Pay Calculator

[kevinm12]

Hi all,
I have a Holiday Pay spreadsheet with 40 men on it. Coolum k lists the total pay and column L has his hourly rate on. There has just been a 5% increase on the hourly pay I don’t want to amend every mans individual pay, is there a quick way i can add 5% to the total pay or the hourly pay?

Thanks in advance
Kevin

[Simon Lloyd]

=k2/100*5+k2

[royUK]

You can use pasteSpecial - see the method explained in the article on PasteSpecial here