ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Forms (https://www.excelbanter.com/excel-discussion-misc-queries/21969-data-forms.html)

Ann Shaw

Data Forms
 
Hi I have a spreadsheet that I am filling in using a form.
I have also a row at the bottom with blank rows in between
with a running total. When I print there is a huge gap
between the last entry in the form and the totals at the
end. Is there a way that the form can enter the next line
and push down the totals so that there are no gaps.
This is what I have.

Name Salary Tax Total
Ann 42000 5000 37000
Joe 37500 6000 31500



Total 79500 11000 68500

This is what I want

Name Salary Tax Total
Ann 42000 5000 37000
Joe 37500 6000 31500
Total 79500 11000 68500

and then when I add new info with the form it can push the
total line down and calculate as normal. Is this possible?

Thanks
Ann


All times are GMT +1. The time now is 11:45 AM.

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