look up pivot table

  1. U

    VBA Vlookup & Pivot Table (Get Sum)

    Hi Team, I have this data with 100K lines and badly need to get a macro as I do this over and over again. This is the scenario: "Master" tab - Main Data Sheet "Reference" tab - Country reference sheet 1.) In the "Master" tab, what I need to do is add a blank column where the macro looks up...
  2. U

    VBA vlookup to Reference Sheet & Create a Pivot

    Hi Guys, I have a massive data set that needs vlook up and pivot. I have this excel file named "MasterData" with two tabs sheets namely: Master & Reference. The master contains a list of data while reference sheet has list of countries and its equivalent country group. Example Reference...
  3. T

    How to look up data for a cell in a Pivot Table

    I have some raw data as shown in Image 1. I created a Pivot Table for it, mainly just for formatting purposes (the ability to nicely group and expand the sub-items). The Pivot Table is shown in Image 2. I need to display the LastUsageTime for each of the items (UsageName) listed in the Pivot...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top