Is there a way to make a macro that will select each value in a drop-down box
and then copy and paste the results on another sheet in a continuous fashion
to create a look-up table for a formula in another spreadsheet?