Need your help

[john]

This might be hard to explain, but here goes nothing.
I am creating a quote template which will consist of many
worksheets, which once completed only one sheet is visible
to the customer. There are 3 levels of service the rep can
select, from the "Options" Sheet. Each Level can contain
additional options. For Example: If Level one is selected,
then:

A1 B1
1 Option 1 (Y/N)
2 Option 2 (Y/N)
3 Option 3 (Y/N)
4 Option 4 (Y/N)
5 Option 5 (Y/N)

If Level 2 is selected, then it might look like:

A1 B1
1 Option 2 (Y/N)
2 Option 4 (Y/N)
3 Option 6 (Y/N)
4 Option 7 (Y/N)
5 Option 8 (Y/N)

The problem that I run into is if the user selects an
option, it will then appear on the "Quote" Sheet. But it
will not show up line after line. For Example if Options
2, 6, 8 are selected (from level 2) on the "Options"
sheet, the "Quote" Sheet will display it as:

F1
1 Option 2
2
3 Option 6
4
5 Option 8

Since the quote is for the customer, I need it to look
like:

F1
1 Option 2
2 Option 6
3 Option 8
4
5

I have tried using IF Statements to try to get this to
work, but it's not. Please help!! Thanks.

 

[Dave Peterson]

Maybe filtering the data and showing only the non-blank cells is an option???