Relative forumlas when copying between workbooks

Select your cells, and then run the first macro below, which will convert the formulas to strings that will not update when copied and pasted. Copy those cells and paste them into the other workbook. Then run the second macro on both the copied cells and the pasted cells to convert them to valid formulas. Note that the second workbook must have the correct sheet structure to allow the formulas to actually be entered and work....

Please Login or Register  to view this content.

Note, too, that your formula

=+Sheet1!D4

doesn't need the +

=Sheet1!D4