Automatically inserting rows

**ausdiver99** · 06-01-2005, 06:47 PM

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

Don Guillett · 06-02-2005, 10:05 AM

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

--
Don Guillett
SalesAid Software
[email protected]
"ausdiver99" <[email protected]> wrote
in message news:[email protected]...
>
> 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 · 09-05-2005, 10:05 PM

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

--
Don Guillett
SalesAid Software
[email protected]
"ausdiver99" <[email protected]> wrote
in message news:[email protected]...
>
> 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 · 09-05-2005, 11:05 PM

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

--
Don Guillett
SalesAid Software
[email protected]
"ausdiver99" <[email protected]> wrote
in message news:[email protected]...
>
> 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 · 09-06-2005, 12:05 AM

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

--
Don Guillett
SalesAid Software
[email protected]
"ausdiver99" <[email protected]> wrote
in message news:[email protected]...
>
> 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 · 09-06-2005, 01:05 AM

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

--
Don Guillett
SalesAid Software
[email protected]
"ausdiver99" <[email protected]> wrote
in message news:[email protected]...
>
> 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 · 09-06-2005, 02:05 AM

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

--
Don Guillett
SalesAid Software
[email protected]
"ausdiver99" <[email protected]> wrote
in message news:[email protected]...
>
> 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 · 09-06-2005, 03:05 AM

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

--
Don Guillett
SalesAid Software
[email protected]
"ausdiver99" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>