[FONT="]I have an Excel sheet that has about 35 combo box form controls (kind of like the drop down boxes). The outputs are all linked to cells in Column B on another sheet that will be hidden from the end user, as well as a cell next to the combo box. (Seems redundant maybe, but we need the information in a certain format to copy into a report.)[/FONT]
[FONT="]And now for the question: If I want to copy this sheet to gather same information for mulitple scenarios, but update the cell references so that the first sheet links to the output sheet column A and the second sheet links to the output sheet column B, how would I do that somewhat "automatically". I need to create a sheet like this for hundreds of scenarios and don't have endless time to change each control's individual cell link. Please help![/FONT]
[FONT="]And now for the question: If I want to copy this sheet to gather same information for mulitple scenarios, but update the cell references so that the first sheet links to the output sheet column A and the second sheet links to the output sheet column B, how would I do that somewhat "automatically". I need to create a sheet like this for hundreds of scenarios and don't have endless time to change each control's individual cell link. Please help![/FONT]
