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


--
rjlasko
------------------------------------------------------------------------
rjlasko's Profile: http://www.excelforum.com/member.php...o&userid=25844
View this thread: http://www.excelforum.com/showthread...hreadid=392299