ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List box change values based on selection (https://www.excelbanter.com/excel-discussion-misc-queries/180278-list-box-change-values-based-selection.html)

Cam

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


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com