Forum Discussion

paul_julz's avatar
paul_julz
Copper Contributor
Feb 21, 2019

Applying A Price Increase

Hi team.  I need to apply a 5% increase to all dollar values in a spreadsheet that is FULL of imbedded formulas.  Is there a simple way of doing that?  Other than manually? If anyone could help, I w...
excel
Macros and VBA
paul_julz's avatar
paul_julz
Copper Contributor
Feb 24, 2019

Legendry.  I think that might actually work.  It's a spreadsheet I have inherited, and is basically the bane of my life.  I will have a play and let you know how I get on.  Is there a cheeky formula you can apply to change all the values in a column by 1.05% or just copy =Z3*1.05 down all the rows?

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Feb 24, 2019

Hi paul_julz 

 

I agree this is a difficult spreadsheet!

 

I've mocked up how you might go about doing the 5% increase. See Sheet 1 in the attached doc.

 

I then copied the table with the 5% increase and pasted with values over the current ones to ensure that your source table has been updated with the newest values and not the formulas which will break the spreadsheet.

 

 

See how you go?

 

Cheers

Damien