Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving data to a cell, not pulling data to the cell
I am using (=IF(10=MONTH(N16),CELL("contents",H23),H13)) at this time to have
data moved to a cell on different month. But sometimes when the month changes I loss my data and get N/A. Is there a function that will let me send the value to the cell automatic as the {manual Paste Special (value)} does. I what the cells to be as the old DBase data, just the value in the cell for the month and not a function in the data cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving data to a cell, not pulling data to the cell
Try
=IF(MONTH(N16)=10,H23,H13) -- Regards Roger Govier "Yojinbou" wrote in message ... I am using (=IF(10=MONTH(N16),CELL("contents",H23),H13)) at this time to have data moved to a cell on different month. But sometimes when the month changes I loss my data and get N/A. Is there a function that will let me send the value to the cell automatic as the {manual Paste Special (value)} does. I what the cells to be as the old DBase data, just the value in the cell for the month and not a function in the data cell. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving data to a cell, not pulling data to the cell
Formulas can only "pull" they cannot "move" data.
If you want a value-only in a cell you must use the paste specialvalue or VBA event code to place the value in the cell. Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 02:51:01 -0800, Yojinbou wrote: I am using (=IF(10=MONTH(N16),CELL("contents",H23),H13)) at this time to have data moved to a cell on different month. But sometimes when the month changes I loss my data and get N/A. Is there a function that will let me send the value to the cell automatic as the {manual Paste Special (value)} does. I what the cells to be as the old DBase data, just the value in the cell for the month and not a function in the data cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) |