Hi Cathy,
Chip supplied you with a line of macro code and you would have to include it in a macro.

Sub Insert1upfrombottom()
Rows(Cells(Rows.Count, "A").End(xlUp).Row - 1).Insert
End Sub

Instructions to install and use a macro can be found in
http://www.mvps.org/dmcritchie/excel/getstarted.htm

However there is a much better way of doing this, so that you do not
need a blank row before your total row, see
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
and note the part about rewriting your formulas referencing the previous
row so that you use OFFSET..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"sassecathy" wrote in message ...
I'm sorry, but I don't understand what this means. I can't find this
sequence on any of the menus of the toolbar. A little more clarification,
please?

Thanks.


"Chip Pearson" wrote:

Try

Rows(Cells(Rows.Count, "A").End(xlUp).Row - 1).Insert


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"sassecathy" wrote in
message
...
I want to know how I can get a new row to add at the end of my
data entry w/o
having to manually click "insert" "rows".

In column A, there are entries in rows 1-20. The TOTAL of
these rows is
displayed in row 22 of column A. At this point I have 1 more
row to enter
data before there are no rows between the data entries and the
total. This
will be a column that gets multiple entries, and the TOTAL row
will need to
move down to allow for more data.

HOW do I get rows to add automatically when I need them,
instead of having
to manually "insert" "rows" every time I need to make an entry
in this column?

Thanks in advance for your help!