Hello,
I am basically trying to do what is shown in this video. I want to do almost the exact thing except that all the files 538, series1, series2, series3 are in separate workbooks (4 different workbooks). I have tried changing the parts of the formula that make reference to the 538 tab. This seems to work only momentarily until I close both and make changes to the 538. Once I make changes and open the series files, they do not update correctly.
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through - YouTube
I am basically trying to do what is shown in this video. I want to do almost the exact thing except that all the files 538, series1, series2, series3 are in separate workbooks (4 different workbooks). I have tried changing the parts of the formula that make reference to the 538 tab. This seems to work only momentarily until I close both and make changes to the 538. Once I make changes and open the series files, they do not update correctly.
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through - YouTube
