Query - Sorting By Date

**Zan03** · 03-18-2010, 05:46 PM

Hi All,

I have a spreadsheet in Excel where we keep track of all request for quotes.

We track each request by ID number and Date.

Is there a query i can run to pull all records (from range b5 - L5) by date? Please see attached.

Thanks!

**tony h** · 03-18-2010, 06:03 PM

have you tried the "sort" and "filter" tools on the worksheet?

**Zan03** · 03-18-2010, 06:18 PM

haha, yes i have.

But as i have a few similar reports i was hoping to write a query where i can gather all quotes from say, January 1st - Feb 2nd quickly.

**Palmetto** · 03-18-2010, 08:18 PM

Have you tried using Advanced Filter with criteria and the option to copy to another location.

See this link on Advanced Filter with Criteria

Tip: to extract data to another sheet using Advanced Filter, you must start the Advanced Filter on the sheet that will hold the results.