Copying and Pasting a Worksheet
I am copying and pasting a worksheet from another workbook into one I am
using. The worksheet has references to other cells. How can I change the reference to cells in the current workbook as opposed to the cells in the other workbook? |
I like to change all my formulas to text, copy and paste and then change my text
formulas back to formulas. Select your range to copy (whole sheet??) edit|replace what: = (equal sign) with: $$$$$= replace all Copy and paste then change them back (in both worksheets) edit|replace what: $$$$$= with: = replace all Jim Pockmire wrote: I am copying and pasting a worksheet from another workbook into one I am using. The worksheet has references to other cells. How can I change the reference to cells in the current workbook as opposed to the cells in the other workbook? -- Dave Peterson |
All times are GMT +1. The time now is 09:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com