I have a workbook with several sheets, there a 2 cols, SecID, TranID on each
sheet. I need the # of duplicate TranID for each secID. All this should be
done in VBA, The resultset should be

SecID TranID NumOfTimesUsed
1 3 5
1 8 3
etc.

Can I run a union query within Excel, if so what would be the syntax, or is
there another way with this type of result.

Mike