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!

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!

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!

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!

I've tried copying and pasting the insrtow row macro code and am unable
to get excel to recognize it. It does not show up in the macro list
whether I put in a regular workbook or personal.xls.

I also reviewed the macro overview on the website. But no luck.
Security is set to medium and I also tried low. Other macros I recorded
work.

Any suggestions. Thanks in advance.

Thanks

Mike

Press Alt + F11, do insertmodule, paste it into where the cursor defaults
to
press alt + Q to close the VBE and save the workbook, then press alt + F8
and double click the macro to run it
If you are trying the event macro you need to paste it into the sheet
module, right click sheet tab and select view code and paste it there

--
Regards,

Peo Sjoblom

(No private emails please)


"mht53nyc" wrote in message
oups.com...
I've tried copying and pasting the insrtow row macro code and am unable
to get excel to recognize it. It does not show up in the macro list
whether I put in a regular workbook or personal.xls.

I also reviewed the macro overview on the website. But no luck.
Security is set to medium and I also tried low. Other macros I recorded
work.

Any suggestions. Thanks in advance.

Thanks

Mike

Peo:

Tried it just now again. After Alt-F8 the Macro Name Box entries are
blank. (This was in the workbook and not Personal.XLS since I
understand it should not matter).

TIA

Mike

Hi Mike,

(This was in the workbook and not Personal.XLS since I understand
it should not matter).

When you call up the Macro Dialog with Alt-F8, you need to select either the
'This Workbook' or the 'All Open Workbooks' option in the 'Macros in'
dropdown.


---
Regards,
Norman



"mht53nyc" wrote in message
ups.com...
Peo:

Tried it just now again. After Alt-F8 the Macro Name Box entries are
blank. (This was in the workbook and not Personal.XLS since I
understand it should not matter).

TIA

Mike

Norman:

Thank you. There are no choices in the dialog box or dropdown. BTW I am
using Excel 2002 with Service Pack 3. I don't know if anyone has tried
this macro with this config. I ahve to assume that I have corrupted
something. Later today, I am going to try differetn macros to see if it
is a global problem or something specific to this macro. I hope I can
gewt it to work since the funcationality it provides is exactly what I
need.

Thanks,

Mike