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.