Thread: Pivot Table Macro

Hi all,

Thank you in advance for taking the time to read this. Here is my saga:
*Please read whole before you judge that I am a dimwit :D

My boss asked me to make a macro that would create a pivot table. I am aware that there are a lot of posts in and out of this forum that have advice on this matter. I have read through a good number of them and there are two reasons why I have resorted to asking for help in a post.

1. I am a noob when it comes to macros and have difficulty when I have to do tweaking to the VBA code after C/P it into my excel sheet.
2. The excel sheet has ever changing columns and rows. While this is not a unique problem, the information that my boss wants on the pivot table will not always be in, for example, column B. It might very well change to column CCC. The information he wants will always have the same column title though. Also, he wants two pivot tables on the same page.

I have uploaded an example file of what he wants. I put the pivot tables and data on the same worksheet for ease of viewing, but he wants the data in one sheet and the two pivot tables another sheet. Some important notes:
-The info my boss wants are in the columns "Salesperson, Contacted, and Feedback Received" They may not always be in columns D, E, and F.
-This is an example sheet, there will be more columns and rows on the real thing.


I realize that these are simple pivot tables that I can create manually in a minute or two. However, I have to have a macro. Is this even possible to do? I thank all of you Excel/Macro/VBA gods.

Please let me know if any additional information is needed, I will be more than happy to provide it.