#1   Report Post  
Colin2u
 
Posts: n/a
Default adding ROWS

is there a way to auto add rows in a work sheet when there are no more empty
ROWS to be filed and there is more work space rows needed?
i have a row with different colums with text to be filed in. what i want to
do is when i am typing in the texts and reach the end of the last row it auto
add a new ROW of the same settings as the last and if possible have my
documentation continued there.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use DataForm to add new records to an existing table. It will
automatically add the formulas to the new rows.

Colin2u wrote:
is there a way to auto add rows in a work sheet when there are no more empty
ROWS to be filed and there is more work space rows needed?
i have a row with different colums with text to be filed in. what i want to
do is when i am typing in the texts and reach the end of the last row it auto
add a new ROW of the same settings as the last and if possible have my
documentation continued there.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding five new rows every 40 rows in a spreadsheet? Olzki Excel Discussion (Misc queries) 8 May 18th 07 02:14 AM
Adding summaries, rows and pre-population JFH New Users to Excel 1 May 24th 05 08:52 PM
Disable Adding or Deleting Rows and Columns Playa Excel Discussion (Misc queries) 1 January 10th 05 10:23 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM
Adding rows to an array chris w Excel Worksheet Functions 1 December 10th 04 02:27 AM


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"