View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cam Cam is offline
external usenet poster
 
Posts: 165
Default List box change values based on selection

Hello,

Where (website) can I find example, sample and information about how the
use? I am having problem with this feature. I am able to create a list box,
but can't seemed to make it update the data or tie it to the data. I don't
know whether, it's because my data in the column instead of row. Example of
my data.

Sheet with Raw data:
Date ProductA ProductB ProductC
3/10 60 45 10
3/11 30 44 32
3/12 40 24 20

Sheet with list box for ProductA
3/10 3/11 3/12
Product 60 30 40
Target 50 50 50