Hi Guys,

I want to write three (simple to you guys, i think) macros which will pull
out separately the following information.

1st Macro. I have a column which has a lot of random dates of when people
took a specific test, with another column outlining whether they passed or
not. I want to write a macro which will just pull out the people who took and
passed the test in the last week. Is that possible?

2nd Macro. I have a column which has a lot of dates for when people
registered to take a test, along with another column which outlines whether
they have either 'not taken the test', 'failed' or 'passed the test'. I want
to know who has not taken the test 35 days after their registration date. Is
that possible?

3rd and final macro. Again, using the dates when people took the test, i
want to know who failed it in the last week. A column outlining passed,
failed and have not taken the test is available.

Many thanks for your help!

Cheers,
Rodney