Applying a percentage increase to dollar figures throughout a workbook

[Jonny5]

I have a simple price workbook with multiple pages. Each page has
different pricing based on the different products described on the
page. I want to apply a percentage increase to all cells in the
workbook that have Dollar figures. Some cells will need different
percentage increases (only a few of them).

Please help me, I'm not very good at this.

Jonny5

 

[Guest]

Hi Johnny
You can do this with Paste_Special

1) Enter the percentage increase in a blank cell, If you want 5% use 1.05
2) Copy this cel
3) Select the cells you want to change
4) Edit>Paste_Special, check multiply, and hit OK

I don't know of a way to restrict this to dollar values so you may need to select the group of cells you want to change. Text values will not be effected. Formuls will get a *1.05 added to the end

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Jonny5 > wrote: ----

I have a simple price workbook with multiple pages. Each page ha
different pricing based on the different products described on th
page. I want to apply a percentage increase to all cells in th
workbook that have Dollar figures. Some cells will need differen
percentage increases (only a few of them)

Please help me, I'm not very good at this

Jonny