ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adding ROWS (https://www.excelbanter.com/excel-discussion-misc-queries/43930-adding-rows.html)

Colin2u

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.

Debra Dalgleish

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



All times are GMT +1. The time now is 08:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com