The best way to describe what I am after is with the excel sheet. The part of the sheet of most interest is rows 47 to 57. In section 5 I have 2 drop down lists at present the first one says 11/U Improvisations and the other says modern/lyrical. When you use these drop down lists the values change according to the submissions sheet. When the drop down list on the left goes to one of the values that says Duos or Trios I need all the formulas from 51 A to 56 L to change to the formulas from 51 M to 56 X. The reason for this is that Duos or Trios require 2 or 3 names whereas the others require only 1 name. I cannot seem to do a mini sheet and I also need 2 different sheets to perform the operations. Is there any way that I could upload the file.