I made an assumption that may be a logic bomb - the assumption that all your
budget end dates would be prior to mid-year. If that is not the case, the
line that reads

mnth = Month(Range("A8")) + 6

is wrong. For anything past June 30 you'll get some factor greater than 5.5%.

I have to head out of here for today, but you can either leave the
assumption alone or add a min check, like so

currFctr = WorksheetFunction.Min(1 + Fctr * mnth / 12, 1 + Fctr)

or roll your own formula.



"spence" wrote:

Thanks a lot. The cell ranges are actually consistent in all my workbooks, so
theoretically I should be able to create a macro that does what you've
described here. (The sheets are PW protected which I never seem to be able to
get past with macros.)

Let me throw a curveball into the scenario. My multiplier unfortunately
isn't going to be 1.055 in all instances but will instead be prorated based
on the number of months left in the budget, which will need to be calulated
based on an existing end date cell (A8). All calculations will be based on
the date of 07/01/07. A budget whose end date is 06/30/08 will need the
aforementioned range multipled by 5.5%; a budget whose end date is 05/31/08
will need the range multipled by 11/12*5.5%, one that ends on 04/30/06 will
have the multiplier of 10/12*5.5%, etc., etc.,etc.

If you have the time and inclination, could you offer a suggestion on this
more complicated scenario? (If it makes you have mercy on my, I work for a
small non-profit who reports to the state and this whole business is the
result of a sudden and unfunded government mandate.)

Thanks again for your time,
spence

"Duke Carey" wrote:

For a single sheet:

Enter 1.055 into an empty cell
Copy it
Select the range of data to change
Choose Edit-Paste Special-Values-Multiply from the menu
Click on OK

For hundreds of workbooks: unless the ranges are all consistent or can be
programmatically identified, you are looking at a manual process


"spence" wrote:

I have a range of cells with dollar values (no formulas) and am wondering if
there is any way to increase the values of all cells in the range by a
certain percentage, say 5.5%. I've got to do this in several hundred
workbooks and so would like to find a way to automate the process.
Unfortunately my range isn't currently named, though that could be remedied
if necessary.

Thanks in advance,
spence