Pasting without changing cell references

[Rebekah]

1) I want to creat two identical tables in the same
worksheet. My first table does not have absolute cell
references, and I don't really want to go through and add
them all in. But I want my two tables to be identical
(reference the same cells). Is there an easy way to copy
and paste the first table without changing the cell
references?

I know there is a macro to convert all cell references to
absolute or vice versa, but I don't really want to do that
either if there is a way to get around it. (ie I want to
keep all my cell references, absolute or relative, the
same).

 

[Don Guillett]

Maybe table 2 could just refer to table 1

 

[Gord Dibben]

Rebekah

Select the table.

Edit>Replace

What: =
With: %%

Replace all.

Copy the table to the new area then reverse the Edit>Replace.

Gord Dibben Excel MVP