Need to pull Data out of Pivot Table into specific cells

I have attached an example. I have (3) worksheets inside of my workbook. I have created the Pivot Table from the Data. What I would love to do is pull the data out of the Pivot Table and make fill it into the "To Print" tab. Can someone tell me how I can do this, or maybe another method? Is there a way to make the Pivot Table always keep the same layout and just fill in the data if it exist? If I could always make it show Bob First and the George second and also show Apples, Bananas, Grapes, and Oranges even if there wasn't any data that fit that criteria, then I know I could do what I need to. By the way, this is just an example. Thanks a ton for any and all help.

Hi Chris,

You can use COUNTIFS to accomplish what you are looking for.

See attached file.

Hope this is helpful.

Cheers

In E5 enter:
=IFERROR(GETPIVOTDATA("Qty",'Pivot Table'!$B$2,"Type",$C5,"Seller",E$4),"")
and then copy/fill to E5:F8.

Hi Chris,

I have had a quick look at your post and would comment as follows.
The "quantities" shown on your "To Print" sheet are based on a "Count of Qty" in your pivot table not a "Sum of Qty".
You need to change the "Values" in your pivot table to "Sum of Qty".
(Unfortunately, because of this, Southward's solution is based on the wrong information)

Regards

peterrc

Hi Chris,

I've had another look and have attached a "solution" using "SUMIFS" and is based on the following:-
1. It's not based on a pivot table
2. I've changed the "Data" range to a Table
3. I've used "Named Ranges" (i.e. columns) to simplfy the "SUMIFS" formula, entered in cell J5 (copied across and down to to K8).

Please let me know if this works for you.

Regards

peterrc

Thankyou all for your responses, I'll look into all of these. I have been out of the loop for a few days. Thanks again