Hi!

The easiest way to do this would be to use a filter and then copy the data
to the other sheet.

How many rows of data are there to search and approximately how many items
will fit these criteria?

If you have 1000's of rows and will have 100's of returns formulas would not
be a very efficient method.

Pivot table?

Biff

"roy.okinawa" wrote in message
...
On my "Overall" worksheet:

I have dates in columns F and T. F will always have a date (start date).
T
will be blank sometimes (close date).
I have text in columns K and O. Some cells will be blank.

On another worksheet I want to do the following:

Each month I need to compile a report of orders that have been opened and
closed within the month. For example: I want to find all dates/text that
fall within 1-31 March 2006.

Date search = column F and T on "Overall" worksheet
Order# = column A on "Overall" worksheet
Booking# = column C on "Overall" worksheet
Part# = column D on "Overall" worksheet
Text = column K and O on "Overall" worksheet

Once that date range is found it would copy data over. It would look
something like this:

__________________________________________________ __________________
Enter date search: mm/dd/yyyy - mm/dd/yyyy

Order# Booking# Part# Text
__________________________________________________ __________________