rows to repeat at the top

[Meebers]

I am working on a single worksheet trying to keep different data on. i.e.
One column has a header labeled "For lease Address" and about 40 rows
later, that same column has an entry "For Sale Address" Data is filled in
under these two sections. I want the rows to repeat at the top for
printing, but change to the other "heading" when I print the "For Sale
Address" data. I cannot think of a way to do that...any suggestions.

 

[Shane Devenshire]

Hi,

Excel doesn't have a feature to do this. You only option is to put a page
break directly before the For Sale Address line. That will put the two
titles at the top of each group. But if the flow over into multiple pages
tall this will not repeat the rows at top.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[Sninkle]

Wouldn't it be better to have worksheet for 'For Lease Address' and another
for 'For Sale Address' then this problem wouldn't occur.

 

[Meebers]

It would...but it is a trade off. One worksheet to view both types vrs 2
worksheets. I am dealing with 8 locations using 8 tabs, vrs 16 tabs if
seperated.

 

[Meebers]

Help...I can't find the "Yes" button :-( but could not figure a way to
do it either. Tx for response.