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): 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 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. :-)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA extract values from pivot table

Thread starter MissingLink
Start date Mar 19, 2018
Tags

data extract data pivot table vba

MissingLink

New Member

Mar 19, 2018

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):

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

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.