Need Help??

[paulwalker]

HI Community,

I have one Application.. in that 3 sheets Daily report and another 3 sheets Monthly reports

total i have 6 sheets.

i have 2 different date fields, Suppose Date and Date1

if i am open my application i want show first 3 sheets based on Max(Date)

second 3 sheets based on Max(Date1)

Thanks in Advance.........

[buzzy996]

hey,what is ur question  here....

hopes,u want open

first 3 sheets based on Max(Date) ? yes u can do it by mapping with same field

second 3 sheets based on Max(Date1)? yes u can do it by mapping with same field

[#3]

You can use trigger "OnActivateSheet" to filter the data by Date or Date1.

Thanks

[Anonymous]

You  can try  trigger

Sheet Propieties-->OnActivateSheet