Hi,

In a Excel sheet I've a list of reports which should be done on daily basis.
I've a check box beside each report name in Sheet 1. Once the report is
finished Check box will be ticked. Once all reports are finished all check
boxes will be ticked.

Now I have to copy the data into other sheet eg. if today I've finished all
the reports all check boxes would be ticked. Now I should get the reports
name which are ticked with the today's date. This should be continuous for
every day..