title: conditional copying in excel
body: <p>hi<br>
  i need some help with vba.   </p>
  
  <p>i know that when you want to copy excel cells based on a condition, you do so by right clicking the sheet and entering the visual basic screen.  </p>
  
  <p>thing is, i'm not very familiarized with vb. i've read some similar posts but haven't been able to understand them completely.  </p>
  
  <p>this is what i want to do:
  i'm making a workbook for chemistry students to illustrate surface tension. what i did was give them 5 different substances to choose from.  </p>
  
  <p>i already have data from reliable sources, so calculations are not a problem.<br>
  thing is, i want to display the results on graphs. i only want them to choose 2 different substances at a time, so i only want to display 2 graphs.  </p>
  
  <p>i don't know how to copy the data from the substances they chose.  </p>
  
  <p>thanks!  </p>