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

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
--

(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
--

(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
--