Rather than fill in the empties with the sums of the items above, consider
using a pivot table which results in :

Sum of amount
num Total
65704 197.11
65705 78.03
65706 4,407.75
65707 1,583.96
65709 12,660.00
Grand Total 18,926.85

--
Gary''s Student


"JimMay" wrote:

I have a couple hundred lines of Check Amts and Check Numbers (as text)
like below..
I need to Loop from bottom to top and Sum the previous amts applicable
to
The same check number. Bottom line ColA should = 12660; 2 rows up
should = 1,583.96, etc up to Row 2.
Can someone get me started?
TIA,

ColA ColB
197.11 65704
65704
78.03 65705
65705
27.85 65706
1691.84 65706
122.98 65706
2275.13 65706
289.95 65706
65706
372.22 65707
57.96 65707
921.05 65707
232.73 65707
65707
12660 65709
65709