title: Excel Macro to create Pivot Table with specifics
body: <p>this is my first question on here, so I apologize for any confusion.</p>
  
  <p>I recently started a new job that deals with pivot tables quite frequently. I have made a simple shortcut by myself to open the pivot table window to speed up the process slightly, but I am looking to do a bit more with it. </p>
  
  <p>I was trying to record a macro that selected a cell inside the information group given, to create the pivot table from that grouping of information, and place it in a new empty cell in the existing document somewhere below the given grouping of information. I believe this may be more of a coding solution, than a macro one, given that the same cell will not always be blank to place the table, etc.</p>
  
  <p>Is there a way to do this by, say, using the current selected cell to make the table, and then placing it maybe 2-3 cells below the current selection? This way I can click on the bottom cell of the information given, and watch the table populate itself below. </p>
  
  <p>Thanks for any help in advance!</p>
  
  <ul>
  <li>Mitchell</li>
  </ul>