question about formula based on another workbook info
Why don't you place the Cound function in workbook B itself, and then link to
the cell that has the count formula from Column A. That way the workbook
will not need to be opened for formula to calculate.
Or you could save Workbook A and Workbook B as a workspace and then open the
workspace when you need to.
--
Kevin Backmann
"Treesy" wrote:
I am trying to use the CountIF function in Workbook A that counts info in a
range of cells located in Workbook B. I'd like Worksheet A to update when
changes to Worksheet B is made. But the function only works if Workbook B is
open, otherwise I get the dreaded #VALUE! error. What am I doing wrong?
Thanks!!
|