Quote:
Originally Posted by MimiCush
Just out of curiosity...Most descriptions of how to do dynamic ranges use offset or index. Your way is so much easier. Maybe I just missed this in my searches.
|
This is very specific technique and applicable at certain limitations only (essentially it is what I used before Tables were introduced to get same behavior as [@FieldName]). But it can get quite complex on it's own. E.g. you can combine several such dynamic ranges to create new dynamic ranges, or you can create a dynamic range or value, which reads data from row in one sheet additionally depending on data in some another sheet.
Quote:
|
The dynamic named ranges worked well on their own (first) sheet. However, from a different (second) sheet I had been using an explicit intersection to pull from the first sheet. Now, these values on the second sheet are all "null."
|
Did you use same named ranges there? Maybe you need different ones for this "explicit intersection" stuff? I can't look at moment what it does - I don't have Excel available currently.