View Single Post
 
Old 03-14-2014, 04:29 AM
Mango123 Mango123 is offline Windows Vista Office 2010 32bit
Novice
 
Join Date: Mar 2014
Posts: 2
Mango123 is on a distinguished road
Default Data validation list filter with range defined by OFFSET

Hi everyone,

I struggle with linking one validation list to another in order to filter my choices.

It usually works well with typing =INDIRECT($A$1), then filtering the list to A1 Name Manager, but it doesn't work in my case.
I think it is so because I used an Offset formula to define my second range.

Can anybody have look ?

Thanks
Attached Files
File Type: xlsm Data validation filter.xlsm (492.1 KB, 18 views)
Reply With Quote