harleyberger
New Member
- Joined
- May 1, 2003
- Messages
- 37
I've got a worksheet that can be anywhere from 2-6 pages long.
Say, in row 3 I have one cell that describes the succeeding rows, for example, 'Ads Aired 1/1/04 - 1/8/04'. After that row I have 'x' rows of data. This data all fits on the first page.
Further down the page, say in row 35, I have another cell that describes the succeeding rows, for example, 'Ads Aired 1/8/04 - 1/22/04'. After that row I have 'x' rows of data. This data spills over onto a second page.
How do I repeat what's in cell 35 on page 2? Also, the row I need to repeat onto the succeeding page might not always be the same. It all depends on how many rows of data follow it. One time it could be row 35 that needs to be repeated, while another time it could be row 46.
Basically, when my data spills over onto another page, I want to keep the header row that describes what is underneath it.
Say, in row 3 I have one cell that describes the succeeding rows, for example, 'Ads Aired 1/1/04 - 1/8/04'. After that row I have 'x' rows of data. This data all fits on the first page.
Further down the page, say in row 35, I have another cell that describes the succeeding rows, for example, 'Ads Aired 1/8/04 - 1/22/04'. After that row I have 'x' rows of data. This data spills over onto a second page.
How do I repeat what's in cell 35 on page 2? Also, the row I need to repeat onto the succeeding page might not always be the same. It all depends on how many rows of data follow it. One time it could be row 35 that needs to be repeated, while another time it could be row 46.
Basically, when my data spills over onto another page, I want to keep the header row that describes what is underneath it.