I'm looking for code that will prompt the user to enter a 'date range'
(2004/01/01-2004/01/28). Using this date range, search an entire
spreadsheet (which will contain many columns of dates) and find each
instance of the dates within the input range. Once all dates are
found, copy and paste the entire
row(s)(including column headings) onto another worksheet within the
same workbook.

The result will be a new worksheet just containing all the rows which
contain dates within the specified date range.

Thanks