Simple Macros (i hope)

[Rodney]

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

 

[Dave Peterson]

It sounds to me that you could use Data|Filter (xl2003 menu) to accomplish what
you want.

I'd add another column that determined how long ago the test was taken:

=today()-a2
(if A2 contained the date of the test)
Format it as general--excel likes to help and you may be looking at a funny
date.

Then apply the data|filter to your columns.

You can filter to show the people who took the test within 7 days. Then filter
on the pass/fail column to show what you want.

If you really needed this mechanized (I'm not sure I would do this), you could
record a macro when you apply the filters that you like.

 

[Herbert Seidenberg]

Try Pivot Table.
Advantages:
Refreshes easily, criteria easily changed, expandable
http://www.freefilehosting.net/download/3a781