I am using Excel 2003: I am trying to adapt a sheet which has 3 columns with drop down lists in each row (about 130 of them). The data for the drop down lists all comes from one separate sheet in the same workbook. Is there a way to change the data source from one page to another for each of these drop down lists without having to change the input range in Format Control for each one individually? Thanks for your help.
Bookmarks