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.
Use triggers at sheet properties on sheet2. Add on activate sheet, Clear All.
Retrieving data ...