Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click on part# in pulldown list fills description cell in next col
I have a list of parts, and I am trying to format the description cell in
column 2 so that if I click on any part in the pulldown list in column 1, it will fill the next cell with the description of that part. At some point I will need to use the same idea to populate other cells with price, cost, labor hours, etc. just by clicking the one part# in column 1. sheet1: col1 col2 col3 part#3 part3 descr part3 cost part#15 part15 descr part15 cost part#2 part2 descr part2 cost sheet2: a1: part#1 b1: part#1 descr c1: part1 cost a2: part#2 b2: part#2 descr c2: part2 $5.25 a3: part#3 b3: part#3 descr c3: part3 $9.80 a3 etc. Am I on the right track so far? I need to list out everything on another page so the formula has a range to look at? And I'm assuming part1 needs to be on the same row as description1 and cost1. I'd like to leave some blank spaces at the end of each list on sheet2 so that I can add to the list without having to go back and edit all the formatted cells on sheet1 with a new range, but I seem to remember blank cells in a range are a problem. Any help would be appreciated - please use small words :) I'm using Excel2003. Thank you, Jules |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click on part# in pulldown list fills description cell in next col
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Jules" wrote in message ... I have a list of parts, and I am trying to format the description cell in column 2 so that if I click on any part in the pulldown list in column 1, it will fill the next cell with the description of that part. At some point I will need to use the same idea to populate other cells with price, cost, labor hours, etc. just by clicking the one part# in column 1. sheet1: col1 col2 col3 part#3 part3 descr part3 cost part#15 part15 descr part15 cost part#2 part2 descr part2 cost sheet2: a1: part#1 b1: part#1 descr c1: part1 cost a2: part#2 b2: part#2 descr c2: part2 $5.25 a3: part#3 b3: part#3 descr c3: part3 $9.80 a3 etc. Am I on the right track so far? I need to list out everything on another page so the formula has a range to look at? And I'm assuming part1 needs to be on the same row as description1 and cost1. I'd like to leave some blank spaces at the end of each list on sheet2 so that I can add to the list without having to go back and edit all the formatted cells on sheet1 with a new range, but I seem to remember blank cells in a range are a problem. Any help would be appreciated - please use small words :) I'm using Excel2003. Thank you, Jules |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click on part# in pulldown list fills description cell in next
Thanks! I think I found what I need on the 03 page.
"T. Valko" wrote: See this: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Jules" wrote in message ... I have a list of parts, and I am trying to format the description cell in column 2 so that if I click on any part in the pulldown list in column 1, it will fill the next cell with the description of that part. At some point I will need to use the same idea to populate other cells with price, cost, labor hours, etc. just by clicking the one part# in column 1. sheet1: col1 col2 col3 part#3 part3 descr part3 cost part#15 part15 descr part15 cost part#2 part2 descr part2 cost sheet2: a1: part#1 b1: part#1 descr c1: part1 cost a2: part#2 b2: part#2 descr c2: part2 $5.25 a3: part#3 b3: part#3 descr c3: part3 $9.80 a3 etc. Am I on the right track so far? I need to list out everything on another page so the formula has a range to look at? And I'm assuming part1 needs to be on the same row as description1 and cost1. I'd like to leave some blank spaces at the end of each list on sheet2 so that I can add to the list without having to go back and edit all the formatted cells on sheet1 with a new range, but I seem to remember blank cells in a range are a problem. Any help would be appreciated - please use small words :) I'm using Excel2003. Thank you, Jules |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set excel pulldown list starting value to current cell valu | Excel Discussion (Misc queries) | |||
Help with hyperlinks in pulldown list. Anyone know how? | Excel Discussion (Misc queries) | |||
Help with hyperlinks in pulldown list. Anyone know how? | Excel Worksheet Functions | |||
Still need help with hyperlinks in pulldown list. Anyone know how | Excel Discussion (Misc queries) | |||
Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel |