Adding some values on a sheet???

  • Thread starter Thread starter Dugholes
  • Start date Start date
D

Dugholes

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
 
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!!
 
Back
Top