| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thanks for the suggestions. Option 1 below was exactly what I needed. It
allowed me to change the source to the new workbook that I copied the sheet into. I didn't realize you could change the source to itself and that would remove the references to the original workbook. "Bill Manville" wrote in message ... If you want the formula to refer to the new workbook's Sheet1 then use Edit / Links / Change Source after copying the sheet in. If you want to move Sheet1 and Sheet2 together to the new book, select both sheets (Ctrl+Click the sheet tab of the second one) before using Edit / Move or Copy sheet. If you just want the values of the formula in the new workbook and not the formula then, having copied the sheet use Select the cells concerned, Edit / Copy; Edit / Paste Special / Values Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| How can I Copy cell names from one workbook to another? | Excel Discussion (Misc queries) | |||
| Link to password protected workbook | Excel Discussion (Misc queries) | |||
| copy a sheet in same workbook temporary block excel | Excel Worksheet Functions | |||
| What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
Threaded Mode
