Copy from workbook to workbook

[BKG SPORTS]

When I copy a list with formula's to another workbook, the columns
come up zero's. How to make this work?

 

[jasonb75]

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.