help with getting named range printed on multiple worksheets

[cliffykat]

Actually it really comes down to the simple fact that I want rows 1 and 2 to reprint on all pages as well as rows 3-10 in columns A and B to reprint. If rows 3-10 in columns A and B need to be on every worksheet that is fine.


Original question:
I have a named "legend" on Sheet1 that is in cells A1:B10, which holds the "Legend" of the colors I am using in other worksheets. I would like to make sure that each worksheet (which spans multiple pages) has the same Legend in the side 2 columns of each page along with repeating rows 2 and 3.

Sheet 1
column a column b
red in jeopardy
yellow at risk
green on target


Sheet 2

column a column b column c column d
row 1 project status
row 2 alpha alpha
row 3 beta
row 4 gamma



would like to print out without having to worry about “Legend” and page breaks ….
Page 1
column a column b column c column d
row 1 red in jeopardy project status
row 2 yellow at risk alpha (red)
row 3 green on target beta (yellow)
row 4 gamma (green)

Page 2
repeat column a and b rows 1 - 3
and row 1

[/list]

 

[cliffykat]

so sorry

so sorry i posted twice. I was viewing over in the lounge and accidentally posted there and when i didn't see my post in board i thought i had accidentally exited before posting so reposted on correct board.

 

[cliffykat]

adding gratuitous self serving bump

bump up, hoping for answer