Hi, I am trying to link a dynamic range, using data validation, the initial part to get a value from col E from a user input of a value for col A works fine :
=VLOOKUP($C$32,'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!$A$2:$E$599,5,FALSE)
I now want the user to be able to select his value for colA from a droplist of values in colA. I have a named range and have defined refers to as:
'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!$A$1:$A$600
This works fine initally, but on reopening workbook it fails - seems to only work when the linked workbook is open.
I want to dynamically define this range - have tried this, but it wont happen :
'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!OFFSET($A$1,0,0,COUNTA($A:$A),1)
Any help much appreciated
=VLOOKUP($C$32,'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!$A$2:$E$599,5,FALSE)
I now want the user to be able to select his value for colA from a droplist of values in colA. I have a named range and have defined refers to as:
'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!$A$1:$A$600
This works fine initally, but on reopening workbook it fails - seems to only work when the linked workbook is open.
I want to dynamically define this range - have tried this, but it wont happen :
'O:xxxxxxxxxxxxxxxxxxxx[xx xx xx.xls]xx'!OFFSET($A$1,0,0,COUNTA($A:$A),1)
Any help much appreciated