Thanks for the quick responce
that would be great if it was just me who dealt with the matrix but other
users who aren't to fluent deal with it and i was hoping if there was a
formula, macro etc that could be inserted that would be great and they would
only have to press print

"cityfc" wrote:

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