Rowsssss?

[Jason Watts]

I need a new row to insert automatically when I am finished with the current row. Here is the kicker it also needs to carry all my formulas with it. I will be very impressed if any one knows how to do this, I have not found an answer anywhere. Please Help!!

 

[Ron de Bruin]

Hi Jason

http://www.j-walk.com/ss/dataform/download.htm
This Dataform will do what you want(Free)


This is a example if you want to use a macro
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

I need a new row to insert automatically when I am finished with the current row. Here is the kicker it also needs to carry

all my formulas with it. I will be very impressed if any one knows how to do this, I have not found an answer anywhere. Please
Help!!

 

[J.E. McGimpsey]

Start with David McRitchie's INSRTROW() Macro:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

To insert automatically, you can use a worksheet_change() event
macro (see

http://cpearson.com/excel/events.htm

for more on events and event macros), but you haven't given enough
information to help much - what does "when I am finished with the
current row" mean to you?

 

[Ken Wright]

Use Data / Form

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Best wishes to all, and hope for a good New year
----------------------------------------------------------------------------

I need a new row to insert automatically when I am finished with the current

row. Here is the kicker it also needs to carry all my formulas with it. I will
be very impressed if any one knows how to do this, I have not found an answer
anywhere. Please Help!!

 

[Norman Harker]

Hi Ken!

Is Rowsssss what you have got in your Pocketses Excel?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ken Wright]