Multiple Pivot Tables and Pivot Chart with very Simple Macro

[@irfanias]

This work & automation is unbelievable!! hats off Nabil Sir. Love from India

[@venkatiyer7459]

Nabil Sir ... I couldn't believe my eyes that I could do it after watching your video step by step ... of course I made mistake and I cleared the macro and did once again ... thank you so much

[@kamleshrana391]

Very nice. Explained in lucid way

[@felipegarduno7949]

Excellent tutorial my friend.Thank you so much

[@nadeemjohn6126]

Excellent Tutorial Sir! Great Effort. Thank you very much.

[@LotfyKozman]

Great efforts as usual. Thanks.

[@Officeinstructor]

Thank you for the continuous encouragement متشكر جدا

[@MAsOCLisMO]

Nabil, thank you so much for the help but I would like to know how to make that macro but using a button in a another worksheet.

[@saremammar9246]

Cool Video Thank You Dr. Murad

[@Officeinstructor]

You are welcome my friend

[@gosuprateja]

Very good presentation

[@Officeinstructor]

Thank You

[@aermecsales7350]

Nice one

[@Officeinstructor]

Thank you

[@camilali8913]

Very good tutorials every time! Thank you so much!

[@Officeinstructor]

Thank you... Glad you liked it

[@venkatiyer7459]

My smiley is not in color when I added the same to the QAT ... any specific reason !!!!

[@sasavienne]

An excellent tutorial.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟 🌟

[@Officeinstructor]

Thank you Salim

[@Robert8455]

Very impressed by your high quality presentation. No stumbling over what to say, clear and concise steps and several excel tricks rolled together. You have a new subscriber for your efforts!

[@Officeinstructor]

What a nice comment... Subscribe to my blogsite to receive a Free copy of my text book"Pivot Tables from Zero to Hero"

[@devshah7936]

In mine it is showing subscription out of the range

[@ساجدصديق]

A wonderful..Empty cells cause a problem in the Pivot Table and appear in print that I want to cancel or not show

[@faizaziz6024]

Great, Useful and helpful.

[@samyraad5258]

Nabil , that’s amazing , could you please create food cost calculator , showing margin and cost % with a pie chart . That’s will be helpful.

[@Officeinstructor]

Thanks Samy. That's a good idea by the way which could lead us to much more topics. I kindly ask you to send me detailed raw data and requirements to think how I can build a project out of it. Check my company website for my contact information.

[@samyraad5258]

Officeinstructor appreciate the fast reply,i dont have any raw data in hands, but can be a simple example for food recipes, like tabouleh With drop down list for kg, grams exc. And to make it more attractive we will add reset button, tank you much and keep up the great lovely lessons . Samy

[@laurisolja]

Great tutorial. I got so much out of it! Do you have any idea why I get error's for my Macros if i use any kind of Pivot Table in them? I've followed every step you showed in this video but when running the macro I've just recorded I get error '424' or '5' and the Pivot Table doesn't look right.

[@yacniandou2753]

Hi thanks. Awesome

[@Officeinstructor]

Thank you

[@yacniandou2753]

Officeinstructor . Thanks. Looking for a simple way to drill down data in a dashboard worksheet based on 3 worksheets customers, invoices and payments. Kind of relationships in Excel

[@Officeinstructor]

Very easy to do in Power Pivot

[@tamerghounem1181]

mazing

[@sunilsidam]

How to creat buttons in sheet with this pivot table

[@Officeinstructor]

I created that in other videos

[@venugopal7161]

Good morning Nabil sir I am big fan of you.But my concern is try to publish your excel videos at least one video for a week sir.I am very much anxiously waiting Nabil sir.

[@Officeinstructor]

Thank You Venu Gopal for being a loyal fan... I will do my best to post more frequently... Stay Tuned. Nabil Mourad

[@nathanwalsh3829]

uhhhgggg.. the video was great but you didn't show me how to record the pivot chart :( my recording does not work :(

[@Officeinstructor]

Select any cell in the Pivot Table and hit Alt + F1

[@Tina-gp4rg]

100000 likes

[@Officeinstructor]

100,000,000 Thank You :)