Copy from workbook to workbook

BKG SPORTS

Board Regular
Joined
Jul 16, 2010
Messages
136
When I copy a list with formula's to another workbook, the columns
come up zero's. How to make this work?
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
10,842
Office Version
  1. 2019
Platform
  1. Windows
Thats because you don't have the source of the formula in the new workbook.

If you just need the results in the new workbook, not the formula use pastespecial values instead, this does mean that changes made in the original workbook afterwards will not be reflected in the copy.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,019
Members
409,675
Latest member
audeser

This Week's Hot Topics

Top