Moving table

[thapelo1]

I am doing a years budget. Sheet 1, I have created the ff tables: Variable
Costs, Standard Costs and Loan Repayment Schedule. Each of these contains
formulas which give out montly totals.
I have then created a 4th table for the monthly instalment (this table has
formulas that use info contained in the other 3 tables). I want to move this
table to sheet 2. Copy and paste gives the ff errors: #NAME? and #REF? How do
I move this table and still maintain my formulas?

 

[Otto Moehrbach]

If you want to move the table and retain the formulas as they are, do this:
Select the entire table.
Click Edit - Replace
In the space for what to replace, type "=" without the quotes.
In the space for what to replace it with, type "#####" without the quotes.
This makes all your formulas text.
Move/copy the table.
Reverse what you just did with the table in its new location. HTH Otto