marco/formula
 

Is it possible to write a macro or use a formula to have data from one cell,
from an exact date to move to another cell or sheet? And still keep the data
in the original cell intact?

marco/formula
 

Formulas cannot push, only pull.

You would need a formula in the other cell or sheet to pull the data from
the original, which would remain intact.

Or VBA code to copy the cell to where you wish.

Show us an example of your layout.

Which cell to copy and where is the exact date located?


Gord Dibben MS Excel MVP

On Wed, 26 Aug 2009 17:41:01 -0700, Se31H1O4
wrote:

Is it possible to write a macro or use a formula to have data from one cell,
from an exact date to move to another cell or sheet? And still keep the data
in the original cell intact?