View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NickR2 NickR2 is offline
external usenet poster
 
Posts: 7
Default Create 2 sheets, from one, based upon value of one column

We have a spread sheet with several columns of data, and one column which is
yes or no (thanks for the help with that one, by the way).

We would like to have all rows with a "Y" in column 8 (for example) show up
on Sheet2, and all with a "N" show up on Sheet3.

I am having a terrible time trying to do "IF" "THEN" requests.

Thanks
NickR