Does anybody know how to have a dynamic selection onActivateSheet or similar, which selects all weeks from week 1 and until current date. I am doing a cost/budget comparison, and needs to have all pasts weeks selected. I have a field to hold the week number : k_Week.
First, I tried to make a search to establish a bookmark, but I cannot come up with the right expression. Tried expressions like this: "<=week(ReloadTime())", but without luck. Neither I can search with =Week(Today()). This selects all weeks every time.