You could use a filter to do that. Select your table, then use Data Filter... Auto Filter. Then
use Custom on your date field, and some combination of "Less than or equal to", " Greater than or
equal to" etc. will allow you to only show the rows with the dates that you are interested in,
prior to printing.

HTH,
Bernie
MS Excel MVP


"cityfc" wrote in message
...
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