Copying a table to another worksheet

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

I want to copy a table to another worksheet. The table has lots of
lookups etc. When I copy the table top a summary performance worksheet
the values in the table do not reference the other worklsheet which I
need them to do for the table to work. How do I do this please?

Cheers

Brian
 
Do you mean that you want to copy the table to another worksheet in a different
workbook?

And that the pasted formulas refer to the sheets in original workbook?

If yes to both, then this is what I do when I want that:

Before you copy the sheet, change all the formulas to text.

Select all the cells
edit|replace
what: = (equal sign)
with: $$$$$=
replace all

Then do the copy

And then do the edit|replace in reverse -- in both the original worksheet and
the new worksheet.
 
ps. If that doesn't help, you may want to go into a little more detail in your
response.
 
Back
Top