I would like to filter the whole document to only show multiple headers when an item within the section is being ordered, without hiding rows, is this possible? IE quantities appear in first section (see B10), show header (Row 10), show only line items with quantities (Row 12) IE quantities appear in third section (see B22), show header (Row 22), show only line items with quantities (Row 24, 27) IE quantities appear in fourth section (see B29), show header (Row 29), show only line items with quantities (Row 30, 44, 51) Rule: always show Row 150 and beneath
Solved by E. C. in 26 mins