hi

"Unless otherwise stated all my comments are directed at OP"

Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code

how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito

how to say no convincingly

most important thing you need
Martin Wilson: SPV
and RSMBC

Please consider:

Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]

My Recommended Reading:

Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges

One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.