what I want to do is to step through the records which are sorted by a key
field, then a subkey. I want to combine the info part number for all that
have the same key in to the last record of the key, then mark the other
records to be deleted.

I have not done any programming in Excel, and what programming I have done
was wayback in dBase3 days.

conceptually, this is what I have come up with, but I am not sure how to do
this in VB. And I am not sure if this is the best approach.



function cleanparts

i=row()
x = column()
testvalue= value of cell(ix)
vString =""

do while cell(row(i),column(x)) = testvalue
cell(row(i), column(x - 4)) = "marked for deletion"
vString = cell(row(i), column(x - 3)) & ", " & vstring
i=i+1
enddo

'last row, do not mark for deletion
cell(row(i), column(x - 4)) = " keep"

return vString

Thanks!
Mc