N
NeedToKnow
Hi all,
I have stuck one more problem. I tried to search through earlier questions
but didn't find solution.
I have 2 files, first has product code (column A), name and another
information between and batch amount in packaging column J and kg column K.
In second file there is column A the same product code (6 numbers) and
column G is total amount per year, H is total amount kg per year. I have
formula
=COUNTIF('[File1.xls]Sheet1'!$A$3:$A$316;A2)
and it works fine if source is open. After source is closed or only file2 is
opened and updated, error #VALUE! appears. Is this avoidable and if so,
how...?
I have stuck one more problem. I tried to search through earlier questions
but didn't find solution.
I have 2 files, first has product code (column A), name and another
information between and batch amount in packaging column J and kg column K.
In second file there is column A the same product code (6 numbers) and
column G is total amount per year, H is total amount kg per year. I have
formula
=COUNTIF('[File1.xls]Sheet1'!$A$3:$A$316;A2)
and it works fine if source is open. After source is closed or only file2 is
opened and updated, error #VALUE! appears. Is this avoidable and if so,
how...?