title: How to select table rows/complete table?
body: <p>The setup:
  I have an excel doc with a form for entering data, the data for that form is entered in a table to allow for easy entering of multiple rows of data. At least i thought so. </p>
  
  <p>So right now i am trying to select the table to insert its data in the appropriate places. My question, i think, is this: do i select one table row at a time, or the whole table and deal with each row separately. And how do i do that?</p>
  
  <p>I tried <code>Sheets("Form").Range("dataForm[#ALL]").Select</code> and several variations thereof and none worked.</p>
  
  <p>If i select the table as a whole i need to be able to deal with each row seperately and if i select each row individually i need to be able to be able to start at the top of the table as the data must be in order.</p>
  
  <p>Any ideas?</p>
  
  <p>EDit: To add detail.
  I have a form as stated above and its data must be inserted in different tables dependent on the value of certain cells in the form. For ease of discussion we will name that cell type, it has three possible values, as defined in a dropdown. Those values are income, expense and transfer. Based on those values we decide which table to add the data to. Income to the income table expense to the expense, etc.</p>
  
  <p>So what i am trying to do is select as many rows as there are and insert each one into the correct table. The sorting is slightly more complicated than i have explained but if i can figure out the initial sort then it should be simple to sort it a few more times.</p>