Thanks for all help in advance. I am using excel to store data in rows. Each row has an order and the date that the order is needed to be ready at. All I need is to be able to search for a specific date and pull those orders that are on that date. If I could spit that data to another worksheet that would be great and then I'll be able to play with the data and make it look how I want it.

I just need help pulling all the data and having it put to another worksheet.

so for example how would i enter the date to search for and then pull all rows with that date maybe up to column p.

any help would be great!

Chip