Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |