Sheet Level Association

[#1]

Hi,

       i attached two files one is Sheet1 and other one is Sheet2.

My requirement is suppose i click on year (List box) values, i need to display corresponding values in Sheet1 only,no need to display in sheet2.

Can we do this one.

[stabben23]

Hi,

Use triggers at sheet properties on sheet2. Add on activate sheet, Clear All.