Open both workbooks. Select the cell in the first workbook with th
formula you want to copy. Place your cursor on the Formula Bar at th
top of the sheet and click and drag to highlight the entire formula.
Press Ctrl+C (to copy) then press the Esc key to deselect that cell.
Now go to the cell in the second workbook and press Ctrl+V (paste).
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.