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

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?

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?

.

Maybe I should explain what Im trying to do a little better. I have dates
in cells in column C and a conditional format that will change the color of
that cell when the date in the cell is past todays date. I would like for
the info in the row of the cell that was changed by the format to be copied
into a different sheet. So if C8 is changed can the info in A8, B8, and C8
be copied to the next worksheet. I hope this makes sense and helps

"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?

.