I think I know what you need.

How comfortable are you with Macros?

I can set one up for you that will filter out what you want, copy those
rows and bring over to the second sheet.

If my understanding is correct. In Sheet1, you have 2500 rows of data,
and in A1 is that date of these data. and you want it to be filtered out
so that only rows that are within certain dates gets copied over to
sheet2.

This can be easily accomplished with a Macro.

If that is indeed what you need, go ahead and tell me and I will whip
one up for you. I do need to know what 5 column other columns you need
and if those are the only 5 columns with data.


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=572736