MissingLink
New Member
- Joined
- Mar 19, 2018
- Messages
- 1
Hi everyone,
I'm trying to work with a macro for extracting values from a pivot table to another sheet ("Sheet2").
The sheet with pivot table is as followed (blue is Data Source list and red is Pivot Table):
<tbody>
</tbody>
I would like to extract the data from "Count of Liste des ingrédients" in column A of Sheet2 and the data from "Row Labels" in column B of Sheet2, without the Grand Total and its related value.
Let me know if you are missing some information, I tried to be as precise as possible.
I'm trying to work with a macro for extracting values from a pivot table to another sheet ("Sheet2").
The sheet with pivot table is as followed (blue is Data Source list and red is Pivot Table):
A | B | C | D | E |
Liste des ingrédients | ||||
X | ||||
Y | Row Labels | Count of Liste des ingrédients | ||
Z | X | 2 | ||
X | Y | 1 | ||
YY | Z | 1 | ||
etc | etc | 1 |
<tbody>
</tbody>
I would like to extract the data from "Count of Liste des ingrédients" in column A of Sheet2 and the data from "Row Labels" in column B of Sheet2, without the Grand Total and its related value.
Let me know if you are missing some information, I tried to be as precise as possible.