Expanding Worksheet Not Sure if possible

I have a worksheet that has six pages that data can be entered into, on the bottom of the sixth page there are formulas for the total of 4 Columns

My question is

Is there anyway to only have one page which data can be entered into and once this page is full it will add another page. my problem at the moment is that if I only have 1 page with data in it when i print the worksheet it prints the first page and 5 additional blank pages. If this can be done can the total of columns on the last sheet be on the bottom of the number of pages printed.

I hope this makes sense as it is hard to put into words

Mooseman,

Maybe it would be easier to come up with a small sample file to illustrate your issue. It's a bit hard to picture what you need.

Why do you need to do this. Using Excel 2007 you can convert your data to a Table which will expand as you add data & you can turn on the feature that adds a Total Row at the botom

Mooseman, don't change a post that has received replies. It breaks the sequence and logic of responses. If you want to change or amend your question, do so in a post withing the thread, but don't change the initial question.

I have restored the initial question.

In Excel 2003 you can use an Excel list and display the totals. The list will expand when you add new data items and the totals will update automatically.

In Excel 2007 you can insert a table, and again, insert a total row, which will update dynamically.

cheers,

Click a cell in your table, then Insert ribbon > Table

Tick Total row on the Table Tools ribbon that appears when the active cell is within a table.

I've selected the "input area" (row 19 to 22) and used Data | List | Create List (my list has headers checked) to convert the data to a List.

You will find that if you type in the last row of the list it will add a row.

You need to tweak the total formulae so that they include the new rows.

And, if you choose to repeat rows 1 to 18 and insert a page number in the footer, you should have a multi-page estimate ... oh, and remove the Page Break.

I'm a bit concerned about the macros you have running as something is slowing this down significantly.

Regards

Why does your Profile say Excel 2007? Read this

maybe

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save