Hi guys,
in my excel worksheet i have a list like below
date___________incoming
01/01/2010_______1000
01/01/2010_______1000
02/01/2010________500
03/01/2010________600
04/01/2010________800
04/01/2010________200
useing the calendar component i am able to insert a date i like to a cell (example 04/01/2010), the question is how can i filter my list to get the last 2 rows of my list to another destination of the worksheet, and of course when i select an other date in the calendar it will re filter the list.
I am using a similar functionallity with the radio button selector component, Insertion Type: Filtered Rows, but there is not such an option in calendar component.
thanks.