ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy Formula to Different Workbook (https://www.excelbanter.com/excel-worksheet-functions/42087-copy-formula-different-workbook.html)

rookerr

Copy Formula to Different Workbook
 

How do I copy a formula from one WORKBOOK to another WORKBOOK?


--
rookerr
------------------------------------------------------------------------
rookerr's Profile: http://www.excelforum.com/member.php...o&userid=26588
View this thread: http://www.excelforum.com/showthread...hreadid=398581


swatsp0p


Open both workbooks. Select the cell in the first workbook with the
formula you want to copy. Place your cursor on the Formula Bar at the
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).

Done!

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=398581



All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com