Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ausdiver99
 
Posts: n/a
Default Automatically inserting rows


Hi.

I have a sheet used for account reconciliations which requires a
variable number of rows between 20 and 120 depending on the volume of
transactions for the billing period. The final row has totals for some
columns in the rows above. Some cells in the data rows have embedded
formulae.

I would like to setup say 5 data entry rows in the sheet so the entire
sheet is visible in the screen and that the printed sheet doesn't
include many empty rows and then have Excel automatically add an
additional row above the total row when the user inputs any data into
cells in row 5. This is analgous to conditional cell formatting.

These auto-added rows would need to include all formatting and embedded
formulae for the data entry rows. This process would then need to be
repeated when the user adds data into the new final row (row 6) and so
on....

Any ideas would be appreciated!

Regards

Pete


--
ausdiver99
------------------------------------------------------------------------
ausdiver99's Profile: http://www.excelforum.com/member.php...o&userid=23958
View this thread: http://www.excelforum.com/showthread...hreadid=375834

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
Inserting Rows w/formulas question Buckwheat Excel Worksheet Functions 4 May 7th 05 10:05 PM
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? Phil A. Excel Discussion (Misc queries) 1 April 19th 05 04:10 PM
inserting rows through external data source [email protected] Excel Discussion (Misc queries) 0 April 5th 05 03:16 AM
inserting a row between two existing rows Jennie New Users to Excel 6 January 8th 05 02:48 PM
Inserting Multiple Rows with Formulas ShineboxNJ Excel Worksheet Functions 2 November 18th 04 03:30 AM


All times are GMT +1. The time now is 09:06 PM.

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"