I have yet another question regarding dependent lists. I have currently made a dependent list formula in data validation, where it restricts what users can choose from (eg: Only allow user to choose American countries from American region).
I am using this data validation formula:
This formula however, only works if the references i made from (eg title cell: $A$28) are from the same sheet.
I would like to use this formula in another sheet of the same workbook (with reference to another worksheet like this: Settings!$A$28), but i am not sure how.
Is there anyone that could help me with this issue? Thanks