title: How do I select data from the excel pivot table?
body: <p><a href="https://i.stack.imgur.com/ccxA2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ccxA2.png" alt="Pivot Sheet"></a>
  <strong>Pivot Sheet</strong></p>
  
  <p>So for example when I click the cell <code>G14</code> in the pivot sheet. It should display <code>9 data</code> in another sheet say Sheet1. The number of data depends on the cells in <code>column G</code> of pivot sheet. I cant seem to find any code to get that data.  </p>
  
  <p><a href="https://i.stack.imgur.com/46XBz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/46XBz.png" alt="Sheet1"></a>
  <strong>Sheet1</strong></p>
  
  <p>I need to to know how I can access that data using VBA.</p>