i don't know of a formula way.........
i know a couple of other ways.......

1. enter the formula down the column as far down as you need & set
conditional formatting to make the text white if the first column on
that row is empty. then you won't SEE all the formulas sitting
there. the trouble with this method is it will make your page(s)
automatically as long as you dragged down........... so even if you
only have entries in column A to row 10, if you've dragged the white-
text-formula down to row 100, that's what your used range will be for
printing pages - not a problem but you've got to manually change the
page range, thn.

2. set up a worksheet_change macro that everytime a cell in column A
is changed/info entered, the appropriate formula is entered into the
other column. harder to do but will make your life (potentially)
easier.

if you want help with #2, let me know.
hope this helps!
susan




On Apr 19, 6:54 am, Dreamstar_1961
wrote:
Is it possible to have a formula to feed down automaticly, as I don't know
how many entry's there will be, and having mutible formulas on every line,
I'm looking for a way that I can put a formula in and when the data is
entered into the first column , the formuia will move to the next line.