In my application i have three sheets and in first sheet i have list box with name called "Lot No" and in the second sheet i have a list box called "IMM" and in the third sheet i created a chart with name "IMM".
Now my question is in my first sheet when i select all the values in list box "Lot No" the values in the second sheet for the "IMM" list box in the "BcShotFlowIndexA" the values are 328 and 422. And in the third sheet the values are same.
But when i select only first one i.e. "B00C7XV" in list box "Lot No" the values in third sheet are changing for "BcShotFlowIndexA" are 329 and 386. But this change is not applying for second sheet list box "IMM- BcShotFlowIndexA".The values are 328 and 422.
I need to get values changed in the second sheet list box also.For your better understanding i am attaching my application.
