LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
extract data from a date range Detin8 Excel Discussion (Misc queries) 2 March 29th 10 05:09 AM
How do I count the number of records within a date range Mike New Users to Excel 6 May 29th 08 05:45 PM
How to copy records containing a specific date range to new sheet? Chrys Excel Worksheet Functions 1 January 30th 06 08:19 PM
count records in a date range jiml Excel Discussion (Misc queries) 3 January 10th 06 08:28 PM
Counting unique records based on date range aspAddict Excel Worksheet Functions 3 October 26th 05 08:12 PM


All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"