I am creating a spreadsheet where I have created a drop down cell that contains a set list of options. Once this cell is filled out from the drop down list I have been copy-pasting from another worksheet within the same workbook. I imagine this task is possible with some sort of excel wizardry...