G
Guest
--
SgtBob
SgtBob
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
S
SteveW
There is no MOVE
I can't think of a use for a MOVE so
Explain what you'd like to do
Steve
I can't think of a use for a MOVE so
Explain what you'd like to do
Steve
G
Gord Dibben
No.
Unless you have a typo and meant MODE
Worksheet functions cannot move data.
They can only pull from another source.
Gord Dibben MS Excel MVP
On Fri, 8 Sep 2006 14:25:02 -0700, Bob <[email protected]> wrote:
Unless you have a typo and meant MODE
Worksheet functions cannot move data.
They can only pull from another source.
Gord Dibben MS Excel MVP
On Fri, 8 Sep 2006 14:25:02 -0700, Bob <[email protected]> wrote:
G
Gord Dibben
Describe what you want done.
I'm sure someone will find a solution.
Gord
Gord Dibben MS Excel MVP
I'm sure someone will find a solution.
Gord
No.
Unless you have a typo and meant MODE
Worksheet functions cannot move data.
They can only pull from another source.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
G
Guest
Well, I have a specific use for the missing 'MOVE' command. As in the old
days, we would use a 'PUT' or 'POKE' command. Anyway, we have a string of
DDE data coming into our spreadsheet in two cells (say A1 and B1). The data
is scrolling through a series of 10 particle counters but not always in the
same sequence. Hence, the A1 cell is the sensor ID and cell B1 is the raw
data. As the data comes in we test it for ID and would like to place it in a
cell specific for that ID. The easiest approach (If we could do it) would be
the statement "=if(A1=X then DX=value of B1 else leave DX as is)" The idea
being to move the data to permenant cells for further manipulation. Right
now the 'else' feature of the if command forces a change to the target cell.
Need to have a sensor specific location for the data to work with. We have a
work around that uses circular logic but that is not very elegant.
days, we would use a 'PUT' or 'POKE' command. Anyway, we have a string of
DDE data coming into our spreadsheet in two cells (say A1 and B1). The data
is scrolling through a series of 10 particle counters but not always in the
same sequence. Hence, the A1 cell is the sensor ID and cell B1 is the raw
data. As the data comes in we test it for ID and would like to place it in a
cell specific for that ID. The easiest approach (If we could do it) would be
the statement "=if(A1=X then DX=value of B1 else leave DX as is)" The idea
being to move the data to permenant cells for further manipulation. Right
now the 'else' feature of the if command forces a change to the target cell.
Need to have a sensor specific location for the data to work with. We have a
work around that uses circular logic but that is not very elegant.