title: copy all rows from dataset for each unique value present in one column to new sheets in vba
body: <p>Problem </p>
  
  <ol>
  <li><p>I have a sheet in which first i have to filter the last column.</p></li>
  <li><p>For each unique value  present in last column, I have to copy data from first column to last-1 column</p></li>
  <li><p>Then I have to add new sheet and need to paste this data in new sheet.</p></li>
  <li><p>I repeat same process 3 for each unique value present in last column. Like in last column is of language. so first sort this column. then copy and paste data for each language in new sheets.</p></li>
  </ol>