Return Relative Reference Value based on Page Break

[rjj920]

Hello Again,

I've got the following code that creates a page break for every change in a defined column (starting after row 3 to accomodate my table header).

I repeat the header on each page through Print Tiles. My goal would be to be able to have the Row above the repeated tiles reference the new changed value.

Please Login or Register  to view this content.

[PCI]

The code you sent seems incomplete.

[rjj920]

I am attempting another routine that forgets about using the Print Tiles Feature and just manually copying/pasting the first two rows during the page break loop but I keep getting an error that the copy/paste area isn't the same size.

I feel like something a long these lines should work, but I can't seem to figure out the right words to use to make this happen.

Please Login or Register  to view this content.

[PCI]

See next code and file attached : Sheet "Original" page setup is changed.

Please Login or Register  to view this content.