I have an excel spreadsheet and need to modify it so
1. If TOSSED!A16 is 'Meal Deal 1', populate
? ? ? ? a) B16 and B17 with select list containing Choices!A13:A67
2. If TOSSED!A16 is 'Meal Deal 2', populate
? ? ? ? a) B16 with select list containing Choices!B13:B28 and Choices!B30 to B17
3. If TOSSED!A16 is 'Meal Deal 3', populate
? ? ? ? a) B16 with select list containing Choices!C13:C20 and Choices!C22 to B17
4. If TOSSED!A16 is 'Meal Deal 4', populate
? ? ? ? a) B16 with select list containing Choices!D13:D36,? Choices!D38:D45 to B17,? Choices!D47:D50 to B18 and? Choices!D52:D59 to B19
5. If TOSSED!A16 is 'Meal Deal 5', populate
? ? ? ? a) B16 with select list containing Choices!E13:E18,? Choices!E20:E34 to B17,? Choices!E36:E43 to B18 and? Choices!E45:E77 to B19, Choices!E79:E92 to B20, Choices!E94:E104 to B21
then copy and paste TOSSED rows 14-23 several times down the sheet
## Deliverables
any version of Excel up to Excel 2003