View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niall Niall is offline
external usenet poster
 
Posts: 5
Default 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