Forum Discussion

Copper Contributor

Feb 22, 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

Copper Contributor

Feb 24, 2019

Hi there

Thanks for answering. I have attached the spreadsheet which I was trying to do all of that manually, but there is no much imbedded in it that I just can't work out how to do it.

Cheers

Julie

MASTER Thermawood-Metro Quotation Tool NZ Price rise 2019.xlsx907 KB

Damien_Rosario

Silver Contributor

Feb 24, 2019

Hi paul_julz

Thanks for the sample.

There's a lot here and I'm not sure which sheet you are looking to do this on and where you expect to see the result.

Are you able to please provide some specifics so we can advise on the best way forward? E.g. on what tab and which cells you want something in, etc.

Cheers

Damien

paul_julz
Copper Contributor
Feb 24, 2019
Hi there

In particular, I am looking at all dollar values on the parts pricing tab and the glass price list. Does that make sense?

Cheers

Julie
- Damien_Rosario
  Silver Contributor
  Feb 25, 2019
  Hi paul_julz
  
  Yup got you now. I'm not a maths expert, but wouldn't increasing values in column Z, AA, AB, AC achieve that as the other fields in GlassList tab reference them?
  
  Similar suggestion for Parts Pricing tab values in say column T.
  
  Cheers
  Damien
  - paul_julz
    Copper Contributor
    Feb 25, 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?