If you have a list of tasks, and each item is marked as daily, weekly,
or monthly, you can use an AutoFilter to view one type of task.

To apply an AutoFilter, select a cell in the list, and choose
DataFilterAutoFilter.
From the dropdown list in the Task Type column, choose Daily, and only
the daily tasks will be visible.

There are instructions in Excel's Help, and he
http://www.contextures.com/xlautofilter01.html

Joe wrote:
Hi,

I have some command buttons such that each button label as
daily, weekly and monthly in which when i click on weekly
task, it can display the list of the tasks to be run
everyday and also the list of the tasks can be deleted or
inserted.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html