Moving cells with formula but leaving originals behind

[DavidGilmour]

I want to drag a table to another area of the worksheet but leave the original table in place. If I copy and paste the look ups will be wrong. Dragging works for the new location but obviously doesn't leave anything behind.
Is this possible?