Filter issue / Printer dilemma

[lisa274]

Thank you for entertaining my problem.

This is for a custom home designer. We offer many options for custom homes and I want them all on one sheet to pick and choose. Each OPTION is in column B and check or not in column A. Filter for only those checked in A and I have my custom list. PROBLEM: how do I print this long, thin list without it looking dorky. I would like to print 2 "lists" per page.

Because I have more columns than A and B on a worksheet I can make 2 lists but then when they are filtered they would filter each other out and would filter row 15 whether something was in one list or both.

Another problem is that I want this list to pull ROOMS to add to the list from another sheet. I can list every ROOM I can think of but when I add ROOMS my formulas dont work on the list - it doesnt keep up with them (maybe because I added rows or maybe because of filtering).

I use the ROOMS on my list for when the Feature List says "hardwood floor in:" and then next lines need to say each room that Hardwood is mentioned as the floor choice. This is repeated with Carpet, Tile, etc. So I make sure all room floors are covered. Right now the list is in Word and we hope we dont make mistakes. Not good enough for me. I want this in Excel to pull all the information from the same source. Yet there are so many variables. Maybe I am thinking about this incorrectly.

[lisa274]

I got it. I treat it as a really long list and truncate with the filter. then I can print like a booklet. it isnt exactly what I want but very close.