Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row height changes when copying and pasting | Excel Discussion (Misc queries) | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Copying and PAsting using MACROS | Excel Worksheet Functions | |||
Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) |