Getting data from another sheet using dates & description as criteria.

Hi

As my title says, i'd like using 3 criteria(start date,end date, description) in my second sheet to get data that match these criteria from another sheet.

I can do this using formulae, but as the range in first sheet will be big(5000-15000 rows), my pc will be too slow for all these calculations.

I'd like to use this in pc that use Excel 2003.

Any idea to do this using code?

Thanks in advance.

You ca use a recorded macro for an Advanced Filter. The code here is slightly edited but is based on a recorded macro.

Please Login or Register  to view this content.

See the attached example.

Apologize for the delay. Really hard day....

I have issues to get it to work in my real workbook. I get an run -time error 1004 ! and this part of code is highlight yellow!

..AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Sheet2").Range("v1:x2"), _
CopyToRange:=Sheets("Sheet2").Range("A5:C5"), _
Unique:=False

V1:X2 IS THE AREA a1:c2 of your sheet

I suspect that i do something wrong with the advanced filter...

What do you mean when (in your instuctions) saying :

Then use an Advanced Filter
You can refer back to the selection cells
(moved to E1 to G3)

Aplogize. As i said it's a hard day!!

No headers. This was the problem.

Than you very mutch!

You're welcome. Thanks for the rep.

I'm sorry, I probably should have left your input area where it was ... but I didn't, I moved it so that I could use the original area for the filter criteria. That needed to be transposed (columns to rows). Then the criteria cells have a formula to pick up the values from the input area. The formula for the start date is =">=" & F1 but note that BOTH date headings are just "Date" rather than Start Date and End Date.

Hope this is clear. Sounds as though you have it working now.

Best wishes for the New Year!

Regards, TMS

Heres another

Please Login or Register  to view this content.

Mike.

Of course this also works perfectly!

Thank you.