Select on Activation of a sheet.

[#1]

Hi,

I need to slect two Years, current and previous year on moving Activation of purticular sheet. I have a list box and it has Calendar year and I need to have current and previous year selcted on this list box on activation.

thanks in Advance

[PrashantSangle]

Hi,

Go to Sheet Property->triger->select OnActivateSheet->add Action->select in Field

Regards

[#3]

HI

For selecting single year, current year it is working. but i need to select current and previous year.

[rubenmarin · Accepted solution]

Hi saritha, configure that action like this:

Field: Year (name of the field)

String to search: ='("' & Max({1} Year) & '"|"' & (Max({1} Year)-1) & '")'

[#5]

Hi Ruben,

thanks for the quick response. its working perfectly.

[PrashantSangle]

Hi,

You can use | symbol for conctenate two value selection.

Regards