Cell references

[deanop2]

I have a wookbook with 3 sheets. Live orders, done orders and job data. In the job data I have a reference to live orders, it's =live orders A2 and so on. When I move the data in row 2 the cell reference in job data moves to the done sheet. How do I keep it in A2 when I move the data, when it's moved we delete the row

 

[PeteWright]

I'm a little confused... not really sure what values move and where to.
If it's only the cell reference, do the following:

='Live orders'!$A$2 -> "static" cell reference (fixed column and row), stays no matter what happens to "Live orders" A2
='Live orders'!$A2 -> "partially static" cell reference (fixed column but relative row)
='Live orders'!A$2 -> "partially static" cell reference (relative column but fixed row)
='Live orders'!A2 -> "dynamic" cell reference (relative column and relative row)

But I think this may not be what you need to know.
Could you post an example?

 

[deanop2]

I'll try to describe the steps.
Job data in A2 is =live orders A2
When I copy the data in live orders from all of Row 2 and paste it in the done sheet, I deleted the row from live orders.
Whe I go to done A2, the reference is =done and the cell it was pasted into

 

[deanop2]

The job data was a table, I've removed the table and something else happened.
When I've copied row 2 from live orders to done and delete row2 in live orders. A2 in job data shows #ref and a3 now shows =live ordersA2