I want a new row be created under the one I'mworking on,
with the same formula as the one above (same formula for all rows). So
everytime I enter text to the last row in the sheet, a new row with
formula will be created under it.

BTW I'm total newbie.. so please.. be gentle



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Manually, you could just copy that last row and paste it below the last row.

Then wipe out the constants in that new row.
Select the row and Edit|Goto|Special|Constants|Ok|then hit the delete key on the
keyboard.

If you need a macro, David McRitchie as a version at:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

merola wrote:
>
> I want a new row be created under the one I'mworking on,
> with the same formula as the one above (same formula for all rows). So
> everytime I enter text to the last row in the sheet, a new row with
> formula will be created under it.
>
> BTW I'm total newbie.. so please.. be gentle
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson
(E-Mail Removed)

Thank you...Its the makro I need, I'll try it out.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Merlola,

Another possibility: You may be able to use "Extend list formats and
formulas." It's in Tools - Options - Edit. YOu insert a row, then when you
fill in values, it automatically copies formulas down into that row. Also
copies formatting.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"merola" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I want a new row be created under the one I'mworking on,
> with the same formula as the one above (same formula for all rows). So
> everytime I enter text to the last row in the sheet, a new row with
> formula will be created under it.
>
> BTW I'm total newbie.. so please.. be gentle
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>