Copy picture from Excel to Power point presentation

See if this helps.

@dflak Look like is working but...it does not take the actual numbers in the text boxes attached to the picture (not a chart or table). it only takes the picture (which plays a background role only)

EDIT: Actually I figured it out.

Is there a way to run through Pivot table filter and export each outcome to PP?

This really should have been asked as a separate question, but I’m not going to make you go through that – but do remember for the next time.

The simplest way to change a pivot table filter is to use VB code to write the value into the cell that contains the filter – this works provided the value is string data and you provide a valid value.

You can pass dates, but they must be in string format, and they must be of the same format as the pivot table is expecting. In other words if the pivot table is using “mm/dd/yy” and you pass “mm/dd/yyyy” it’s going to think it’s a different value.

This technique doesn’t work if you want to select multiple values, but you can pass the string “(All)” and it will work.

In the attached spreadsheet. The pivot table whose filter we want to change is in columns F:G. The pivot table filter is cell G1.

I have a second pivot table in column I. This table gives me a unique list of the months – each of which is a valid value for the pivot table. Pivot tables are the easiest means of getting a unique list of values.

I overlaid the pivot table with a named dynamic range: MyMonths =OFFSET(Sheet1!$I$2,0,0,COUNTA(Sheet1!$I:$I)-1,1)

I run through this list in the code and set cell G1 to each value in turn.

I will explain first the way I have my dashboard set up:
1. First I have a picture that is used as background in Scorecard sheet
2. Multiple text boxes that contain figures off a pivot table on a "Pivot" sheet
3. On the Pivot sheet I have two pivot tables using the same data source but for two different years (2015 full year KPI, and 2016 monthly KPI), but different cities (in a separate slicer) .
4. My Objective is to have the macro run through each city option (in a slicer or not - I have a slicer to do it manually), populate the dashboard (it will do it anyways) and export the scorecards as picture in a Powerpoint presentation on different slides.
At the moment for some reason it exports 8 of them in line for the first city/port.

Without the workbook itself, I can only offer a general solution.

First of all it is easier to populate the two filters using VBA rather than to use the slicer. To use the slicer you would have to loop to turn on everything and then loop to turn off all but what you want to see. This has to do with the fact that Pivot table filters have to have *something* selected and it is possible that you can turn off whatever is selected before turning on what you do want to select.

As far a copying the ranges, I'm not quite sure what your problem is. If the issue is due to the changing size of the pivot table, you might want to overlay the data you want to copy with a named dynamic range. Named dynamic ranges should work with the pivot table "map." Use the name instead of the coordinates.