Locating a range of dates and listing somewhere else?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically use the newest number input in the formulas 1
Date 8
Count of leader on multiple sheets 1
Unique Output is Duplicating minimum date value 2
Find the most recent date 4
XIRR question 5
AVERAGEIFS Multiple Criteria: use an Array? 7
IRR, XIRR and NPV - a very frustrating problem 1

Top