Find records between two dates & check a box for each positive result
 

Hi all,

I'm hoping someone may be able to start me off in the righ
direction:confused:

I have an excel sheet of approximately 900 rows, I wish to code in
function that gives the user a form to enter a start date. And the
search through the 900 rows and find all records between (User Input
and now (I believe it will be 7 days).

With each positive result I would like to check a checkbox on eac
record.


Any pointers in the right direction would be greatly appreciated.

Thankyou in advance,


Mark
:confused: :confused: :confused

--
Message posted from http://www.ExcelForum.com

Find records between two dates & check a box for each positive result
 

Sounds like something better done in a sheet

Dates in A2:A900
Enter your search date in B1
Formula in B2:B900. Enter it in b2 and copy down.
=IF($A2=$B$1,IF($A2<=NOW(),1,0),0)

You could then filter the results to just show the valid results, do a sum
to get the number of valids, sumproduct with another column to get a total,
etc.

Robin Hammond
www.enhanceddatasystems.com


"seals " wrote in message
...
Hi all,

I'm hoping someone may be able to start me off in the right
direction:confused:

I have an excel sheet of approximately 900 rows, I wish to code in a
function that gives the user a form to enter a start date. And then
search through the 900 rows and find all records between (User Input)
and now (I believe it will be 7 days).

With each positive result I would like to check a checkbox on each
record.


Any pointers in the right direction would be greatly appreciated.

Thankyou in advance,


Mark
:confused: :confused: :confused:


---
Message posted from http://www.ExcelForum.com/