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?