I have a large database of 20 or so assorted measurements covering a long period of time. Some measurements are available for the full range of dates while others are only available over some lesser range. I just have a list of dates in column one and the rest of the data placed according to the dates that they are available. I am looking to plot many graphs of measurements side by side looking for correlations and other relationships. Each time I make a graph I need to highlight that range of dates for which all the columns in the graph have data available. This seems like a rather agonizing process involving ridiculous amounts of scrolling hunting for the start and end points of the data- also quite often I forget which data belongs in which column since the column label is written on the first row only.
What I would really love to do is simply highlight the columns I'm interested and then have some clever macro/in-built-function/add-on to modify my selections so that they are restricted to only the date ranges where all the columns have values. Am I asking too much?