Help There has to be a btter way to cut and paste

[billyboy630]

I have a worksheet that the user inputs data into and the sheet performs calculations.

On the bottom of the sheet is a nice printable output version. Columns and row text are in Englis I want to create a new sheet with the same output only have the column and row text in spanish so I cut and paste the sheet to a new worksheet but all I get is #REF ?

Any ideas how to do this

[Portuga]

It seems that you are also copying formulas from one to the other.
Try copy paste "values" and then paste "formats" (or vice versa)


NOTE:

Billy, this is not the first time you are posting. You should know by now that cross-posting in several forums is not allowed.

http://www.excelforum.com/showthread.php?t=642018

[royUK]

Closed - duplicate post