I have this great little Macro that Dmille (Dave) wrote for me that auto generates a Survey from a Main Workbook. Here's the challenge, in order to input the data back into the MAIN WB/WS, I need to define the range names of the sets of data in the new Survey WB/WS. I need a macro or macro code within the existing Macro that allows me to specify ranges and range names that get created when the new WB/WS is created. If you build the macro and put in a few hints; I'll put in the range names and parameters.
Thank you in advance,