You can filter the data, and copy it to another worksheet, either
manually or with programming.

Or, leave all the data on one sheet, and use filters to show specific
records.

There's information on AutoFilters and Advanced Filters in Excel's Help,
and he

http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xlautofilter01.html

chusky wrote:
i have a list of properties serviced throughout the year. date in sheet
1 column 3 row 4 is for example 01-04-06. date in sheet 1 column 3 row
6 is for example 28-05-06.I am trying to put the 1st date in sheet 2
(april) and 2nd date in sheet 3 (may) HELP




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html