Forum Discussion
Help with Dynamic Named Range
Since the view here is changing, that isn't what I was looking for. Is it possible with incorporating this into named manager where we could select the range from within the sheets?
I've been thinking about this more, and hope you're willing to hang in here with me for a bit longer. So here's a postscript to what I last wrote. Let me ask that, instead of suggesting a method--"use named ranges, name manager"--you be really clear on how you want the Input end of things, the raw data about each of the companies, to be displayed at the Output end of things. What are the changes that need to be reflected in the Output as we go from week to week? Leave the in between process to me or one of the other frequent visitors to this site.
One of the realities about Excel is that there are always multiple methods, multiple ways, multiple tools, multiple processes, to get from point A to point B. You have seen named ranges, one of those tools, work, so keep referencing it; and that may or may not be the best tool or method in this case.
What we need you to do is to back away from prescribing the treatment and, instead, describe the desired outcome more clearly, regardless of the method used to get there. Leave that latter to me or one of the more experienced users of Excel.
I hope that distinction makes sense.