Sorry about that. On sheet 1 I have conditional formatting that will change
the color of a cell on TODAY() and I want the row with the cell that changes
to be copied to another sheet.

"Gord Dibben" wrote:

Today is April 6th

You want the data tranferred every April 6th of each year or??

Please explain.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 12:55:01 -0700, Lou825
wrote:

I have a workbook and I want info from sheet 1 to be transferred to sheet 2
on todays date. Is this possible?

.