ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Automatically inserting rows (https://www.excelbanter.com/excel-worksheet-functions/28867-automatically-inserting-rows.html)

ausdiver99

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


Don Guillett

Sounds more like a project, which is what many of us do for a living,
instead of a question.

--
Don Guillett
SalesAid Software

"ausdiver99" wrote
in message ...

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





All times are GMT +1. The time now is 11:34 PM.

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