Hi,

I have a drop-down list which looks at a range called scenarioIn with 1,2 and 3 as the possible options. When an option is selected outputs in a range called OutputsW need to be copied and pasted into a ranges called target1, target2 and target3 for the 3 different options. Can anyone suggest some simple code that will help me do this please? I will link it to a macro buton which will loop through when I need to refresh the results.

Thank you

Jeff