Locating a range of dates and listing somewhere else?
 

Is there a macro or formula that allows me to look through data in one sheet
and find those in a certain date range and put the date and the data next to
it in another sheet? For example,

Data in Sheet 1 is as follows:
12/3/2006 WEW
12/4/2006 3424
12/5/2006 WQWQE
1/6/2007 DDDD
1/7/2007 CFDW
1/8/2007 CSF
1/9/2007 CEE
2/4/2007 WYT

In Sheet 2, under each month, Dec 2006 - Jan 2008, I want it to search the
data and find any data in its range and list it and the data in the next
column. So in this case the data in Sheet 2 would look like this:

Dec 2006 Jan 2007 Feb 2007
12/3/2006 WEW 1/6/2007 DDDD 2/4/2007 WYT
12/4/2006 3424 1/7/2007 CFDW
12/5/2006 WQWQE 1/8/2007 CSF
1/9/2007 CEE

Locating a range of dates and listing somewhere else?
 

How many rows of data are there to search on Sheet1?

Biff

"A.S." wrote in message
...
Is there a macro or formula that allows me to look through data in one
sheet
and find those in a certain date range and put the date and the data next
to
it in another sheet? For example,

Data in Sheet 1 is as follows:
12/3/2006 WEW
12/4/2006 3424
12/5/2006 WQWQE
1/6/2007 DDDD
1/7/2007 CFDW
1/8/2007 CSF
1/9/2007 CEE
2/4/2007 WYT

In Sheet 2, under each month, Dec 2006 - Jan 2008, I want it to search the
data and find any data in its range and list it and the data in the next
column. So in this case the data in Sheet 2 would look like this:

Dec 2006 Jan 2007 Feb 2007
12/3/2006 WEW 1/6/2007 DDDD 2/4/2007 WYT
12/4/2006 3424 1/7/2007 CFDW
12/5/2006 WQWQE 1/8/2007 CSF
1/9/2007 CEE