Tags: a2aq500, code, column, contains, date, excel, extract, following, microsoft, msdn, range, records, sheet1, software, table, vba
VBA Code to extract records between a date range
I was wondering if someone could help me with some code for the
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
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.
Leave a comment...
- 3 Comments
- 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
--#1; Fri, 23 May 2008 04:33:00 GMT
- >(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.
"Max" <demechanik.excel.todaysummary.com.yahoo.com> 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
> xl 97
> Singapore, GMT+8
>#2; Fri, 23 May 2008 04:34:00 GMT
- > (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 ..
--#3; Fri, 23 May 2008 04:35:00 GMT