Prev Previous Post   Next Post Next
  #1   Report Post  
pfa
 
Posts: n/a
Default Insert Row

Hi,

I am a beginning user with very limited knowledge of macros. I am looking to
add the following functionality. Presently I have a spreadsheet with enough
room for 32 data input rows before I sum two columns' results (columns D&F in
rows 40 and 41). Obviously, as time goes by, more rows will be needed for
additional input. I would like for the user to, upon pressing the enter key
at the last cell of data input for that last data row entered, to have excel
automatically insert a new row immediately below and move the cursor to
column A for new input. Is this possible without adding too much complexity?

Thanks for all the assistance!!!
Pete
 
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
Simultaneouly insert of rows or col. - Ajit Ajit Munj Excel Discussion (Misc queries) 1 March 23rd 05 09:17 AM
insert a JPEG into EXCEL 2002 mckee Excel Discussion (Misc queries) 3 March 11th 05 05:03 PM
insert picture BillGwyer Excel Discussion (Misc queries) 1 March 4th 05 06:37 PM
Insert Line Macro Spyder Excel Discussion (Misc queries) 1 March 3rd 05 12:17 AM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM


All times are GMT +1. The time now is 04:07 PM.

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

About Us

"It's about Microsoft Excel"