Hi Ron,
I understand that you want to copy and paste cells with formulas from one workbook to another without having the workbook link appear in the formulas in the target workbook. I can definitely help you with that.
One way to achieve this is by using the
"Paste Special" feature in Excel. Here are the steps:
- Select the cells containing the formulas that you want to copy.
- Right-click on the selected cells and choose "Copy" or press "Ctrl+C".
- Go to the destination workbook and select the cell where you want to paste the formulas.
- Right-click on the selected cell and choose "Paste Special" or press "Ctrl+Alt+V".
- In the "Paste Special" dialog box, select "Formulas" and uncheck the "Paste link" option.
- Click "OK" to paste the formulas without the workbook link.
This method will copy and paste the formulas exactly as they are in the originating workbook, without any links to the original file. You can also use the keyboard shortcut
"Ctrl+Shift+V" to open the
"Paste Special" dialog box directly.
Formula:
// No macro or Visual Basic code found in the text.