Tim,

INDIRECT() is what I needed. Thanks,it works like a dream!

Dave

"Tim Williams" wrote:

You could try using INDIRECT() in any formulas which point to the drop
target range.

Tim


"Dave T" <Dave wrote in message
...
I have a need to drag a cell value from one part of a spreadsheet to
another
part of the spreadsheet in such a way that when the values replace the old
values at their new location I do not get a #REF error.

What I'm trying to accomplish is this: I have a list of data that needs to
be arranged manually into a second list in order to assemble a work
schedule.
I want to drag the data from the original data inventory list into the
newly
arranged schedule where calculations will be performed in real time as new
data is added to the new list. (I need to see a running total.) By
dragging
the data away from the original data inventory I can assure that I do not
have duplicates in the new schedule as each data line would be eliminated
from the inventory as it is added to the new schedule.

Right now this can be done by COPYING the data line from the data
inventory
and PASTING it to it's new location and then returning to the original
data
inventory and DELETING the now copied line. However, this is cumbersome
considering the amount of data that has to be moved and re-arranged even
within the new location. Plus implementing a drag and drop process makes
it
super easy to use for anyone.