Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marco to change formula according to what is written in the cell | Excel Programming | |||
Marco | Excel Discussion (Misc queries) | |||
Marco Help | Excel Discussion (Misc queries) | |||
Help with marco | Excel Programming | |||
help me with this marco | Excel Programming |