datawarehouse

  1. S

    How to reference a range of cells containing monthnameshort in GETPIVOTDATA

    I am trying to build a more agile and time limiting financial reporting tool. In this proces I stumpled upon a problem that I can't seem to fix. I am trying to get Year-to-date numbers by referencing a range of cells containing Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep Formula that works for january...
    • sko
    • Thread
    • datawarehouse excel getpivotdata pivottable
    • Replies: 5
    • Forum: Excel Questions
  2. R

    VBA code on Data Warehouse criteria

    Hi I want to use VBA code to update the criteria in the Data Warehouse table I'm using The current code I have is: Sub Macro1() ' ' Macro1 Macro ' ' Sheets("List").Select Range("A1").Select Dim varCellValueList As String varCellValueList = Range("G2").Value...

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