ExcelBanter - How to copy formulas from one workbook to another

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to copy formulas from one workbook to another (https://www.excelbanter.com/excel-discussion-misc-queries/13878-how-copy-formulas-one-workbook-another.html)

Confused

How to copy formulas from one workbook to another

I am trying to copy formulas from one workbook into another. I highlited the
desired cells, selected ctrl c, opened the new workbook and selected ctrl v.
It copied the values in the first workbooks cells, but not the formulas. Any
idea what I am doing wrong?

Jock W

Use "Paste Special" from Edit menu.

"Confused" wrote:

I am trying to copy formulas from one workbook into another. I highlited the
desired cells, selected ctrl c, opened the new workbook and selected ctrl v.
It copied the values in the first workbooks cells, but not the formulas. Any
idea what I am doing wrong?

All times are GMT +1. The time now is 10:09 PM.