I have a dropdown menu with about 10 different selections. I want it to change the data in about 10 different cells on the worksheet. This would be part of a much larger worksheet where the rest of the data would not change. Additionally, some of the data on that sheet is used in formulas on several other sheets in that workbook. If this would require VBA, let me know and I can post this over to that part of the forums. Thanks.