I have directed you to the
solutions to your problems; you really don't need VBA to do this.
Particularly since - as you say - you are not experienced in VBA, an
inflexible VBA solution won't be the best way to help you.

I've given you links to investigate Dfunction and array formulae
solutions. Here is an introduction to pivot tables in Excel - THIS IS AN
EASY WAY TO ACHIEVE YOUR REQUIREMENT; most of us in here believe you
should only use VBA if you can't achieve your aims without it and this
is not such a case.

office.microsoft.com/.../HA010346321033.aspx