I am trying to use the item #24 of the Excel Hacker Book with no success.
" CREATE VALIDATION LISTS THAT CHANGE BASED ON A SELECTION
FROM ANOTHER LIST".
I did everything they ask in this item and I
received a message that
"THE SOURCE CURRENTLY EVALUATES TO AN ERROR. DO YOU WISH TO CONTINUE ? "
When they asked me to Select Data - Validation - Settings. select list form the Allow: box, and in the source box type
Them ensure that the In-Cell drop-dpwn box is checked , and click OK.
Looks like the instruction they put to type on Select - Name - Define for CorrespondingList have something wrong.
The instruction is: =OFFSET(INDIRECT(ADDRESS(MACH(Val1Cell, Objects,0)+1,2,,,"Lists")),0,0,COUNTIF(Objects, Val1Cell),1).
If anybody got this comando work , please let me know what I am doing wrong please.
Sidney Amaral - [email protected]