View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott@CW Scott@CW is offline
external usenet poster
 
Posts: 62
Default Macro to gather comments

Can I use a macro to gather comments from a survey. I have a survey that
pulls the names in column A and the coresponding comments in column H. I have
tried V & H lookups but they only work for the first entry. I may have
anywhere from 0 to 15 comments per name. Any ideas?