After a cell changes colour when a date is near

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


0
cityfc (14)
1/10/2006 12:35:01 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
383 Views

Similar Articles

[PageSpeed] 37

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" <cityfc@discussions.microsoft.com> wrote in message 
news:37C3C1D5-349F-4BD0-9628-15DB2F1954D4@microsoft.com...
> 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
>
> 


0
Bernie
1/10/2006 3:03:17 PM
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
> 
> 
0
cityfc (14)
1/10/2006 3:38:03 PM
You could use a macro like the one below, which would filter the table starting in cell A1, based on 
dates in column B, showing values from today until next week (the  + 7 part).  It will then print 
the table. Assing the macro to a button and the user can just press the button to filter and print.

Post back if you need help getting the specific date range that you want.

HTH,
Bernie
MS Excel MVP

Sub FilterAndPrintOneWeek()

   Range("A1").CurrentRegion.AutoFilter _
   Field:=2, Criteria1:=">=" & Date, Operator:=xlAnd, _
       Criteria2:="<=" & Date + 7
   ActiveSheet.PrintOut
   Range("A1").CurrentRegion.AutoFilter

End Sub


"cityfc" <cityfc@discussions.microsoft.com> wrote in message 
news:0786A0E1-C08F-49B0-8EA1-55C046F7DFA0@microsoft.com...
> 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
>>
>> 


0
Bernie
1/10/2006 3:58:03 PM
Reply:

Similar Artilces: