Adding additional rows with formula

Can some assist me please?

I have a small spreadsheet with 22 rows in it. I want to be able to add an
additional row with formula when any value is put into the last cell which is
d22, adding a row below it will then off course will make the lastcell d23
and so the routine will be triggered again. The spreadsheet has formula in
cell c22 which would need copying down.

Any solutions would be greatly appreciated, I hope I have explained what I'm
after!

Thanks


--
Mark

Mark
What version of Excel are you running? I have 2002 and when I enter
something in D22, the formula in C22 is automatically copied down to C23.
HTH Otto
"Mark" <[email protected]> wrote in message
news:[email protected]...
> Can some assist me please?
>
> I have a small spreadsheet with 22 rows in it. I want to be able to add
> an
> additional row with formula when any value is put into the last cell which
> is
> d22, adding a row below it will then off course will make the lastcell d23
> and so the routine will be triggered again. The spreadsheet has formula
> in
> cell c22 which would need copying down.
>
> Any solutions would be greatly appreciated, I hope I have explained what
> I'm
> after!
>
> Thanks
>
>
> --
> Mark

Oops. The D22 should have been D23. Otto
"Otto Moehrbach" <[email protected]> wrote in message
news:[email protected]...
> Mark
> What version of Excel are you running? I have 2002 and when I enter
> something in D22, the formula in C22 is automatically copied down to C23.
> HTH Otto
> "Mark" <[email protected]> wrote in message
> news:[email protected]...
>> Can some assist me please?
>>
>> I have a small spreadsheet with 22 rows in it. I want to be able to add
>> an
>> additional row with formula when any value is put into the last cell
>> which is
>> d22, adding a row below it will then off course will make the lastcell
>> d23
>> and so the routine will be triggered again. The spreadsheet has formula
>> in
>> cell c22 which would need copying down.
>>
>> Any solutions would be greatly appreciated, I hope I have explained what
>> I'm
>> after!
>>
>> Thanks
>>
>>
>> --
>> Mark
>
>