View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] rtilghman@gmail.com is offline
external usenet poster
 
Posts: 19
Default Using list values as variable in secondary formulae... best way?


Took a snapshot of the component I'm talking about and building in the
hopes it helps to illustrate what I'm trying to do. Click the link
below to see the gif.

http://www.tilghman.net/ConvergenceTool.gif

Basically I want to give the user the ability to select from a defined
list ("Data Point Name" with the arrow), and then have the labels
along the top and the data values change appropriately. I can do this
by just providing the right variable, I just have to figure out how to
provide that variable when a value in the pull-down is selected.

Thanks,
Rick