In my example I have two sheets, Data and Analyze.
If I store a named range in the Data Sheet, lets call it mydata.
Can I access the named range from the second sheet Analyze?
OR
Is the only way possible is the named range must be stored in the documnet to access across sheets?