10 Replies Latest reply: May 19, 2009 11:46 PM by Rakesh Mehta RSS

    Macro to pass values from summary to detail levels

    Stuart Wenzel

      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?