View Single Post
  #1   Report Post  
GRIFFO
 
Posts: n/a
Default Copy worksheet without absolutle references

How do you copy a workSHEET from one workBOOK to another workBOOK, without
the absolute references to the original workBOOK being contained in the
formulas, AND keep the original formatting of the workSHEET.


That is, it seems to insert [original_workbookname] in front of my formuals,
and thus is creating a link between the two workBOOKs. I dont want a link, I
just want to copy the formulas as they are, and the formatting from one
workBOOK to another workBOOK.

Your assistance is appreciated.
Griffo