Copy and Paste
 

How do you copy a complete worksheet and when its pasted into a new workbook
all the referances, macro, print setup go along with it. When I do a copy a
worksheet to another workbook the graphs (source) still points to the
original file.

Thanks,

Paul H

Copy and Paste
 

It sounds like you want to make a copy of the sheet. Use Edit, move or copy
sheet. Then check make a copy and select where you want it (new book or
other open workbook)

"Paul H" wrote:

How do you copy a complete worksheet and when its pasted into a new workbook
all the referances, macro, print setup go along with it. When I do a copy a
worksheet to another workbook the graphs (source) still points to the
original file.

Thanks,

Paul H