Sort random numerical values that end in xxx-1 through xxx-4

[DJClark]

I haven't played with macros for a couple years, I think this one is beyond my abilities right now. Have a large data set (100K+ rows of data in multiple worksheets) that I need to sort and compile so I can compare delta values by Batch #'s ending in -1 vs -2's or -3 vs -4's. The batch # is a numeric sequence that ends in either a -1(a,b,c), -2(a,b,c), -3(a,b,c), or -4(a,b,c).

Batch	Date (MMDDYY)	Initials	Weight (mg)	delta H (J/g)
130402-2a	4/3/2013	pjv	5.64	119.0
130402-2b	4/3/2013	pjv	5.53	114.7
130402-2c	4/3/2013	pjv	5.74	118.5
Avg.H=	117.4	Range =	4.3
Batch	Date (MMDDYY)	Initials	Weight (mg)	delta H (J/g)
130407-3a	4/8/2013	pjv	5.70	119.6
130407-3b	4/8/2013	pjv	5.28	119.2
130407-3c	4/8/2013	pjv	5.42	117.3
Avg.H=	118.7	Range =	2.3

<tbody>
</tbody>

<tbody>
</tbody>

Thanks for any help!

<tbody>
</tbody>

<tbody>
</tbody>