jrub
10-11-2012, 01:06 PM
I am trying to write a code in vba to change a target cell by a user defined percentage which already contains a value, basically yearly inflat
As an example.
If G4 contains a value of 100 and Start!$C$15 contains the 3% increase, i want the contents of cell G4 to increase to the value of 6%, so multiply by 1.06. Also I then wish to repeat this down from G4 to as many cells as required all using G4 as the target % increase. Not all cells contain data. The adjacent column would then increase a multiplier of the year difference associated with the column, BUILDING SUMMARY'!G$3-'BUILDING SUMMARY'$F$3, giving rise to 1, 2, 3, etc. by column. The multiplier would then be 1*6%=1.06, 2*6%=1.12, 3*6%=1.18, etc.
Any help or suggestions, or even someone who can write the VBA code and post would be most appreciated.
As an example.
If G4 contains a value of 100 and Start!$C$15 contains the 3% increase, i want the contents of cell G4 to increase to the value of 6%, so multiply by 1.06. Also I then wish to repeat this down from G4 to as many cells as required all using G4 as the target % increase. Not all cells contain data. The adjacent column would then increase a multiplier of the year difference associated with the column, BUILDING SUMMARY'!G$3-'BUILDING SUMMARY'$F$3, giving rise to 1, 2, 3, etc. by column. The multiplier would then be 1*6%=1.06, 2*6%=1.12, 3*6%=1.18, etc.
Any help or suggestions, or even someone who can write the VBA code and post would be most appreciated.