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
__________________________________________________ __________________