'page footers' in tables.

[comaboy]

Hi all,

I think this is a one of those 'easy-when-you-know how-to-do-it' questions, and it applies equally to Word and Excel.

OK, so you got a long table spanning multiple pages.

You can as many rows/columns to repeat at the top to sort out your headings. Fine.

But now you want, say, two rows to repeat at the bottom of every page to show subtotals, 'Carried Forward's, etc.


So how the heck do you do it? It's one of those things I've never been able to suss out (without programming at least).

Don't shout Headers And Footers - you can't rely that the'll match up to the table.

If anyone's got an idea, I'd love to hear it - my users ask me this one all the time, and I can't start programming custom functions everytime someone wants to produce a schedule.

Comaboy

 

[randiec]

Have you tried highlighting the rows and going to window and freeze panes?

 

[fkegley]

YOu might try putting some kind of page number value every so often in the table and using Excel's Subtotals function to calculate the needed values every time the page number changes.

 

[comaboy]

randiec,

Freeze panes only works for the top of page.

fkegley,

It isn't the calculation itself that's the problem, it's building a 'repeating footer'.

Maybe I haven't made myself clear, so try this exercise in Word...

* Build a table - 1 column, 200 rows.
* Type something into row 1.
* Click Table->Headings.

If you page forward and back, the heading is repeated for each page. Easy.

Right. Now do the same for the footer to place a matching subtotal or whatever. Note: as far as I'm aware there is no Footings menu command!

Excel.

Same thing again. Build a multi-page table, and format thin interior cell borders. Also format a thick exterior line to border the entire table. You can easily sort out repeating headers, but when you come to print, there is no thick line to "close off" the table. (If you see what I mean) - you have to manually add a thick line at the end of each page... and when you need to add a row half-way through the table, the nightmare begins!

 

[fkegley]

I think you are going to have to write a macro to do this. Decide how many rows of the table you want on each page.
One way to do it would be to have the macro insert a brand new worksheet at its beginning.
Then you would need to loop
place column headings, if desired, on new worksheet
add 1 to rowcount
if rowcount<rowsperpage
copy row to correct place on new worksheet
else
select new worksheet
place custom footers
print the page
delete the area
set rowcount to 0
until all rows moved Frank kegley
fkegley@hotmail.com

 

[fkegley]

I think you are going to have to write a macro to do this. Decide how many rows of the table you want on each page.
One way to do it would be to have the macro insert a brand new worksheet at its beginning.
Then you would need to loop
place column headings, if desired, on new worksheet
add 1 to rowcount
if rowcount<rowsperpage
copy row to correct place on new worksheet
else
select new worksheet
place custom footers
print the page
delete the area
set rowcount to 0
until all rows moved Frank kegley
fkegley@hotmail.com