how do i export information from an answer from a drop down menu?
 

Hi

I have created a drop down menu in one workbook in an excel sheet. The
options available on this drop down menu are yes and no. if the answer is
€œno€� I want that line to export into one worksheet. If the answer is €œyes€� I
want that line to export into a different worksheet.
Is it possible to do this?

Thanks and best regards

Niall