adding a constant number to a column of numbers

It's not very clear what you're doing exactly but if we assume you enter the "adjusting" value in A1 and have the 10 values listed beneath (A2:A11) then you can use a VBA change event

Please Login or Register  to view this content.

to insert the above - right click on tab on which values reside - select View Code and paste above into result window (ensuring Macros enabled thereafter)

Hello,

If you put somethink like =ROW(B1)+$C$1 In B1 and and drag it down. This will adjust by whatever is placed in C1

cheers


Whoot i actually used a formular where DO used code. never though ild see that come.

I used code because my interpretation of the question is such that:

a) the original values need to be updated

and

b) the increment may be repeated

and

c) presuming b) holds true - the next increment would adjust the latest values as opposed to the starting values

If the above holds true then same cell Formulae aren't viable given the Circular requirement would lead to the cells becoming Volatile which is likely to lead to unsatisfactory outputs
(ie results will update with each calculation in Excel as opposed to only when the incrementing cell is updated)

Way to burst my bubble on a folmular i spent 5min on.

I think you need to explain the work flow more fully I'm afraid (pref. by means of example(s))