Copy and Paste

P

Paul H

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
 
W

widman

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)
 
Top