I'd use a PivotTable to group and analyse the data.
no vba needed. MS has done it all for you.

Ever tried them?

a very powerful tool.takes a bit of time to truly learn, but you can
produce your first results in seconds.

see Data Menu in Excel ( and Excel help for your first intro)




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(JCA) wrote:

I get a file with work orders from a client each week. I built an
Access db system to be able to manipulate the data into our forecast
system but recently my client bought a new system and instead of
summing up the quantity needed per part they now have part number by
itself and under part number there is the same partnumber with a
workorder under the partnumber (following row). The work orders are
all a concatenation of the partnumber and a uniquely identifying
workorder number with a dash in between eg if part nummer is 43 and
workorder is 5342 the new workorder number would be 43-5342. The part
number by itself does sometime sum up the workorders into one number,
sometimes not and others falsely so it is important for me to be able
to sum up all the workorders except the top partnumber that does not
include a workorder extension. I need to be able to sum up all the
partnumbers that have a workorder extension to them. So for example if
I have a list
43
43-5342
43-5325
43-1221
I want to be able to sum up the 43-5342, 43-5325, 43-1221

All help is greatly appreciated as I am not very good at writing Excel
Macros!

Thanks!

JCA