Hi, I am trying to set a trigger that will make an autoselection when acitvate the sheet.
The selection I want to make is all finished months current year. If I example enters the sheet todag (March 26) the correct answer should be 201201 and 201202.
Do you have a master calendar table in your load script? This will probably be the cleanest way to do what you want. In the master calendar you can then add a flag for complete months in current year and use a trigger on the sheet to select this flag when the sheet activates.
