Hi everyone! I'm struggling with a formula and I'm hoping someone can help.

On "sheet 1" column A (rows 2 - 36) I have a listing of different assembly option descriptions that a person could pick from. The user picks the particular option(s) by placing a "1" (instead of a "0") in the column D field of that row.

On "sheet 2" column A (rows 33 - 38) I have blank rows in which I would like to have populated with the actual option description from "sheet 1" ONLY when a "1" has been selected.

In other words, if the customer selects five (5) options from "sheet 1" then only those five option selections would show up on "sheet 2". (Sheet 2 becomes the summary document without the detail from sheet 1) I hope that makes sense.

Now if a person selects 10 options is there a way to have sheet 2 "grow" to accomodate the more options that were selected?

Thanks in advance for any help.

Rich