Need help with a formula
 

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

Hi, Rich. I have a tutorial that does something very similar. Perhaps it
will help you. See:
http://www.officearticles.com/tutori...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com


"rjlasko" wrote in
message ...

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

On sheet 1, you could add another column, in which you number the
selected items. For example, in cell E2, enter:

=IF(D20,MAX($E$1:E1)+1,"")

On sheet 2, in cell A33, enter the formula:

=IF(MAX(Sheet1!$E$2:$E$36)<ROW()-32,"",
INDEX(Sheet1!$A$2:$A$36,MATCH(ROW()-32,Sheet1!$E$2:$E$36,0)))

and copy down as far as required.

rjlasko wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

That's exactly what I was looking for! Thank you VERY much! :)


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

You're welcome! Thanks for letting me know that it helped.

rjlasko wrote:
That's exactly what I was looking for! Thank you VERY much! :)




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html