Skip to Content
0
Former Member
May 19, 2010 at 06:17 PM

Calendar component question

29 Views

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.