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

Damien_Rosario

Silver Contributor

Feb 22, 2019

Hi paul_julz

Maybe provide a screen shot or sample file of what you are working with if possible. Hard to know what to answer without seeing what you are working with.

We can assess it once we see the example?

Cheers

Damien

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