Hi, friends
here i just need <acronym title="visual basic for applications">vba</acronym> code to delete last line of each group!!
Sheet 1
<tbody>
</tbody>
Sheet 2 output like this
<tbody>
</tbody>
I apreciate so much your help!
here i just need <acronym title="visual basic for applications">vba</acronym> code to delete last line of each group!!
Sheet 1
05 | 06 | 31 | 39 | 44 | 49 |
06 | 18 | 22 | 29 | 37 | 44 |
04 | 08 | 12 | 16 | 27 | 44 |
09 | 24 | 26 | 37 | 44 | 46 |
05 | 20 | 21 | 26 | 31 | 47 |
08 | 10 | 22 | 26 | 31 | 37 |
08 | 14 | 26 | 36 | 39 | 42 |
05 | 09 | 34 | 38 | 39 | 42 |
04 | 22 | 27 | 36 | 38 | 46 |
06 | 21 | 22 | 37 | 41 | 42 |
03 | 16 | 18 | 19 | 37 | 42 |
07 | 10 | 22 | 25 | 32 | 43 |
02 | 19 | 25 | 30 | 32 | 39 |
01 | 12 | 14 | 31 | 32 | 46 |
10 | 19 | 21 | 24 | 33 | 35 |
<tbody>
</tbody>
Sheet 2 output like this
05 | 06 | 31 | 39 | 44 | 49 |
06 | 18 | 22 | 29 | 37 | 44 |
04 | 08 | 12 | 16 | 27 | 44 |
09 | 24 | 26 | 37 | 44 | 46 |
08 | 10 | 22 | 26 | 31 | 37 |
08 | 14 | 26 | 36 | 39 | 42 |
05 | 09 | 34 | 38 | 39 | 42 |
04 | 22 | 27 | 36 | 38 | 46 |
03 | 16 | 18 | 19 | 37 | 42 |
07 | 10 | 22 | 25 | 32 | 43 |
02 | 19 | 25 | 30 | 32 | 39 |
01 | 12 | 14 | 31 | 32 | 46 |
<tbody>
</tbody>
I apreciate so much your help!