outputting values to a range from one formula

S

Shafee

I wish to generate a table automatically by means of a single
formula that applies an iteration on a starting given value with
a given step, and the computed values are posted/entered
automtically into cells from a given cell onwards, say below
it, until the computed value reaches a certain given limt.
This is somehow the inverse of INDIRECT or of OFFSET. These
can pull values from a variable addresses of cells. What I need
is to push values into a variable addresses of cells.

Can anyone help me on that??

Thanks. :confused
 
A

AlfD

Hi!

A bit more detail would be helpful.
First the distinction between "pull" and "push" is effectively th
difference between using a function in a cell to pull in a value an
using VBA to push a value into the cell.


More to the point, however, can you indicate the sort of sequence yo
want to generate; is it linear ; where and how it gets its "seed" an
end value.
e.g. if you wanted (trivial case) to start in A1 and put 21,23,25,2
etc in col A, then A1 = 21; A2=A1 + 2 and copy A2 down does it.
condition to limit the values to less than a given value (MAX) woul
maybe look like =if(A1+2>MAX,"",A1+2)

But I think you might have something more complex in mind? If so (an
bearing in mind you would have to have the above formulae in "more tha
enough" cells) VBA would be my choice.

What you describe is pretty much what Edit>Fill>Series does, if all yo
want to do is a "one-off".


Al
 
Top