is it possible to have the contents of a cell change based upon the "printed" results

Is it possible to have the contents of a cell change based upon the "printed" results of another cell:

In other words:

I have a sheet that has a repeating row.

When printing, I'd like the content of H2 to be different based upon the contents of D10.

I can do this with a simple formula so it shows what I want but then it prints the results on all pages.

I can't figure out how to change the contents of H2 based upon the printed results.

I know this probably doesn't make any sense so, please ask questions.

Bruce

I figured it was easier to eliminate the repeating line and create new lines with the desired contents.

Sorry for the post.

Bruce