VBA Code to extract records between a date range
 

Hi there,

I was wondering if someone could help me with some code for the
following:

I have a table of data in Sheet1 (A2:AQ500).

Column A contains dates. Cell A1 contains a date that is a lower bound
and cell B1 contains a date that is an upper bound.

I would like some code that will find all the records with a date
between the lower and upper bounds and copy all these records to
Sheet2.

I figure I need some kind of loop. I'm ok with VBA but just not sure
how to start.

Thanks for any help anyone can offer.

David

VBA Code to extract records between a date range
 

In the interim, perhaps you might also wish to try out
the non-array formulas play (using 2 formulas only)
as responded to your earlier post in microsoft.public.excel
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

VBA Code to extract records between a date range
 

(using 2 formulas only)

You sure about that? <g

Does 21,956 sound more like it?

With that many formulas I would drop the error trap and go with CF.

Biff

"Max" wrote in message
...
In the interim, perhaps you might also wish to try out
the non-array formulas play (using 2 formulas only)
as responded to your earlier post in microsoft.public.excel
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

VBA Code to extract records between a date range
 

(using 2 formulas only)
You sure about that? <g

Of course, I meant 2 "starting" cell formulas,
filled down / across & down <g

Albeit subjective, the recalc's performance for the OP's situation does
appear quite tolerable going by the full formula loading test here ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--