Need help with an Excel Pivot Table and Macro

[tmpollard]

Hello, I really hope someone can help me with this. I have a dataset of thousands of rows from which I created this pivot table. The pivot table is actually only columns A:M, columns N:Q were added by me. I left some formulas in there so you could see what I am doing.

In row 1 where you see 1 through 10 that means the number of shirts that are packaged in the box, problem is that 1-10 might not always be the numbers, sometimes it might be 1-5 or 1-25 so, I guess this is called dynamic.

Row N is an offset number to get me back to row 1

Row O is looking for the number in column P then going up the offset number to get the corresponding number from row 1. If we look at row 3 it means that for item number 102758 that sometimes they are packaged in 4's, 6's, and 7's but 59 boxes were packaged in 6.

This is my goal, from my dataset I have created a macro that creates the pivot table, I would also like to expand the macro to automatically fill in columns O-Q when the macro runs.

Thanks to everyone for looking at this.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Product	Description	1	2	3	4	5	6	7	8	9	10	Grand Total	Offset	Standard Package Count	Count Conformance	Conformance %
2	102795	Blue Shirts	156	*	*	*	*	*	*	*	*	*	156	-1	=OFFSET(A2,N2,(MATCH(P2,A2:L2,0)-1))	=MAX(C2:L2)	=P2/M2
3	102758	Green Shirts	*	*	*	2	*	59	27	*	*	*	88	-2	6	59	67%
4	102757	Yellow Shirts	49	*	*	*	*	*	*	*	*	*	49	-3	1	49	100%
5	102756	Orange Shirts	24	*	*	*	*	*	*	*	*	*	24	-4	1	24	100%
6	102755	White Shirts	5	*	*	*	2	*	*	51	14	1	73	-5	8	51	70%
7	102754	Black Shirts	8	*	*	*	*	1	4	377	*	*	390	-6	8	377	97%
Slits per PPK