Yes, there are formulas there and they are necessary. That's why I need the
work around.

Dave

"JLGWhiz" wrote:

Dave it sounds like you might have formulas in the cells you are trying to
drag and drop. When you try to move those by dragging, it changes the cell
references that they were calculating and produces the #Ref error flag.

"Dave T" wrote:

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.