Hi
Im trying to figure ut if it's a way so solve the above but have not yet found a way.
if we look at a normal cell reference to another workbook it can look like this.
But what i now want to do is to not have to have the text "test.xls" in the formula, instead i want to link that information to another cell where i can write down the name of the file it should look for, the reason is that the test.xls file will be updated regularly so it will be version 1 and then version 2 and so on and i don´t want to have to change all the formulas in the different cells every time.
In my head simply putted it would be something like
Hopefully someone might understand what i mean
Many Thanks for any help i can get.
// Cam12
Im trying to figure ut if it's a way so solve the above but have not yet found a way.
if we look at a normal cell reference to another workbook it can look like this.
Code:
=COUNTIF('[test.xls]Data'!$F$6:$F$65536;'Failures Data'!D12
But what i now want to do is to not have to have the text "test.xls" in the formula, instead i want to link that information to another cell where i can write down the name of the file it should look for, the reason is that the test.xls file will be updated regularly so it will be version 1 and then version 2 and so on and i don´t want to have to change all the formulas in the different cells every time.
In my head simply putted it would be something like
Code:
=COUNTIF('[B1]Data'!$F$6:$F$65536;'Failures Data'!D12
Hopefully someone might understand what i mean
Many Thanks for any help i can get.
// Cam12