When the cell changes to a specific colour say a12 goes red when a date is
within 30 days (a12 is a date an assessment is due) can a12 and a1 (which a
persons name is in a1) be put on a different worksheet and the same for each
row so i can have a list of names and assessments on a seperate worksheet to
print off

so it would look like this

A N OTHER FDA 02-JAN-06
A BODY SUMMARY 02-JAN-06