Could someone please advise me on how I set a trigger to select current year in the table 'YearAsOf' when opening a tab?
I know how to get to the trigger option but unsure what to select / add from here.
triggers--- edit action on open.
Action ...Select in field
Dear go to sheet properties >>Triggers>>Edit Actions>> and follow attachment
Retrieving data ...