Hi I am new to VB and would like to accomplish the following, could someone take the time to push me in the direction I need to go, adn suggest any readings related to the code I will need to write. Currently I have master.xls which refreshes a web query upon open. I would like the following to occur when the user opens master.xls:

Copy web query data,starting from line 2 on sheet 1 and paste to line 17 sheet 2.
Create pivot table: row=Column K;column=Column G;data=Column A.

To clarify, I cannot just pivot the web query as I have 15 "categories" in column k to pivot, example: if there were only two entries in my web query my pivot table would have only two "categories" as opposed to the 15 with 13 having a value of zero and 2 having a value of 1.

Also, I cannot just use a formula to link the sheet 2 cells to sheet 1 as all the empty cells have a value of 0 and therefore skews my pivot table...

I guess an alternative would auto-run on open a macro that links the exact amount of cells as rows in the web query, then pivot???

This is meant to be a report that someone can go in and upon opening everything will be there, they should not have to copy/sort or pivot any data.

Any and all suggestions are greatly appreciated! Thanks in advance!
-Alain