Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding some values on a sheet???
Hello and thanks in advance. I'm working on a calculator for some Cable TV
plants designs. Here is what I need: I'd like to have a drop down menu with several different values of design in it. When I click on a value, I'd like it to insert some "value specific" numbers on this type of chart below...... 30 mhz= Ch 5= Ch 40= Ch 78= Ch 80= Ch 116= Any ideas on how I go about that and where to insert and store the info for each type of "value" Cheers! Doug Strinz Hudson Falls, NY |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding some values on a sheet???
Hi Doug Strinz,
Assume that you have a worksheet named 'master'. On this worksheet in Col A list all your different design names and in Col B list the corresponding value that you want to display. Now create a named range from list in Col A by choosing menu insert--Name Go to your target worksheet and select the range, say A1 to A20. Go to menu Data--Validation and select List. In the 'source' text box hit F3, your named range should be listed. Please select it and click on OK In range B1 to B20 use vlookup to get the corresponding value. HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think a post is useful, please rate it as an ANSWER, it will help others!! "Dugholes" wrote: Hello and thanks in advance. I'm working on a calculator for some Cable TV plants designs. Here is what I need: I'd like to have a drop down menu with several different values of design in it. When I click on a value, I'd like it to insert some "value specific" numbers on this type of chart below...... 30 mhz= Ch 5= Ch 40= Ch 78= Ch 80= Ch 116= Any ideas on how I go about that and where to insert and store the info for each type of "value" Cheers! Doug Strinz Hudson Falls, NY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links | Excel Discussion (Misc queries) | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) |