I have an application that contains both aggregated data (for speed) and detail data. They are contained on different sheets and have no fields in common (and therefore cannot be joined). I have a macro that sets a variable to hide the summary sheets and show the detail sheets. I would like to pass the list box values selected in the summary sheet to the corresponding list box values in the detail sheets. Any ideas?
