help with getting named range printed on multiple worksheets

cliffykat

New Member
Joined
Feb 15, 2006
Messages
13
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]
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

cliffykat

New Member
Joined
Feb 15, 2006
Messages
13
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,187
Messages
5,594,753
Members
413,930
Latest member
Nela817

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top