Hi Sian,
This is a useful method which I have just read about in the past
month...
Type 1.15 in a blank cell (can be in another workbook), [enter], select
& copy the cell (or [ctrl+c]), select the range that you want to be
increased by 15%, edit - paste special - multiply - [enter] (or
[alt+e+s+m] [enter]).
This works on values or formulae, try it on a copy of your file first.
Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=507575