Repeating rows at the bottom of a page

[Alan]

I have a spreadsheet which needs to show data at the bottom of each page. The
customer footer function does not work for me as I need to show data in
boxes. Any ideas

 

[Bob Greenblatt]

I have a spreadsheet which needs to show data at the bottom of each page. The
customer footer function does not work for me as I need to show data in
boxes. Any ideas

What do you mean data in boxes? Why does custom footer not work? What
exactly are you trying to do?

 

[Alan]

Bob,

I need to have boxes in the footer as the spreadsheet is a document which
contains inspection report data and the docuemnt need to have titles
surrounded by 'boxes' as it is a ISO requirement for this particular
document.

I have tried inserting a .Jpeg file which works OK but is fiddley for the
end user.

Any thoughts. And Thanks

 

[Bob Greenblatt]

Bob,

I need to have boxes in the footer as the spreadsheet is a document which
contains inspection report data and the docuemnt need to have titles
surrounded by 'boxes' as it is a ISO requirement for this particular
document.

I have tried inserting a .Jpeg file which works OK but is fiddley for the
end user.

Any thoughts. And Thanks

OK, now I understand better. I've done similar reports to this. I create a
single page worksheet that has all the fixed data and formatting needed. You
might even look at putting some things off to the side and using the camera
tool to place "pictures" of them in the right place on the form. Then I use
a macro to spin through the data, placing it on the form printing it, moving
in the next batch of data printing, and so forth.

 

[Alan]

Bob,

Not sure what you mean by placing it on the form printing it, moving
in the next batch of data printing, and so forth. Could you enlarge on how
the macro might work

Thanks Alan

 

[Bob Greenblatt]

Bob,

Not sure what you mean by placing it on the form printing it, moving
in the next batch of data printing, and so forth. Could you enlarge on how
the macro might work

Thanks Alan

The macro reads a data record, and moves the data fields into the worksheet
prepared as the form. Then it prints the worksheet, and moves in the data
from the next record, prints that, etc.