i need to extract the first and last row of data for each engine ID (there are multiple instances for each engine ID) and put them into seperate work books one for first, one for last test If there is only one test on the engine , it must go in both workbooks. here is a sample of my data, i have 2400 points to go through and dont want to sort it by hand.....not great at excel looking to just get my data and make charts.

Partial Engine ID Imbalance
( x 10-2 in-oz)
1051635 32
2051740 144
2051740 29
2250844 390
2250844 75
2250844 30
2261016 209
2261016 36
2261021 113
2261021 81
2261021 79
2261021 65
2261021 35
2261055 84
2261055 50
2305028 184
2305028 119
2305028 61
2305028 18
2330660 11
2330660 16
2330660 41
2330660 45
2330660 60
2330660 77
2330660 52
2330660 47
2330660 38
2360858 20
2360858 333
2360858 122
2360858 32
2360858 20
2360858 25
2360858 255
2360858 63
2360858 41
2360858 78
2360858 126
2360858 6
2360858 20
2360858 88
2360858 44
2360858 72
2360858 8
2360858 4
2360858 82
2360858 82