Hi all,
I have built a pivot table using power pivot; it's set to tabular view so that Customer Code and Company Name are in columns A and B. When a user clicks on the Company Code or Company Name then the Macro needs to jump to the P&L Sheet and change the customer Code to match...
Option...