Cell Won't Copy Correctly To Second Workbook

Hello,

Hopefully someone can help. I'm trying to copy a cell from one workbook and paste it into another workbook. Both workbooks are open so that is not the problem. The problem I'm running into is that in the first workbook where I'm getting the information the cell is tied to another. And the cell it gets the information from is running a COUNT function. So the problem I run into is that when I go to copy the cell and paste it into the new workbook I'm getting 0 instead of the correct number found on workboook1. Does anybody know how to fix this? Thanks for your help.

use specialpaste values instead of just paste so it will carry over the value and not the formula