This is the only video I could find on the subject. It should be in the top result when searching for "Generate individual separate sheets for excel pivot table data" in google. good job bro.
Ek doubt hai Jo aapne master sheet pe table banaya us table extra details add kaise karein aur mein ek baat aur puch Raha tha jadi ye sab party mein Naya party add karta hun toh uska sheet kaise create hoga
Sirji........ easy & totally understand secret tips....wow. Sir one query :- " aap ka ye same data me muje party wise konsi party ke kitne invoice bane he vo Jan na he ek simple se deskboard pe show karvana he to kese kare..........??? " Jese ki me deskboard pe koi party ka Name search karu to vo fast way me......count karke de.............???. Is se smart work bhi hoga or Boss ka dil bhi Jit lege........🤗 Please requested sir....... Make it ......
What I can do, I need to add 100 people details of Debit and credit,. So what the best method to do that. Which is easy to edit, add ? Please tell or make video
I Only want to keep separated data as values not pivot table as in that different sheets when I click on drop-down all values are showing, I do not want to see other that selected filter, any suggestions?
Select all sheets as shown in the video. Copy the pivot table of one sheet without the first row and paste the copied table below the pivot table. Now delete the pivot table and unselect all sheets. You will have the data as simple tables.
But that filter button is still on the sheet so how can we share with separate people because everyone knows how to unhide so they can see our whole Data Please Help
Hi sir......one query hai meri....mere pass ek data means master file hai usme name, mobile no, city, order, pincode,status - Dispatch & Pending hai. muje master file me se Dispatch & Pending file new sheet me Lana hai.dispatch & pending data separate mean new sheet create honi chahiye. Pending & dispatch 2 new sheet create hone ke baad jab measter file me new data add Karu tab wo data status ke jariye pending & dispatch sheet me add hona chahiye automatically....ye query formula or VBA coding ke kaise solve hogi...plz tell me formula or VBA code.
This is the only video I could find on the subject. It should be in the top result when searching for "Generate individual separate sheets for excel pivot table data" in google. good job bro.
I like to thinking about this topics......vo bolte hena "dariya mese hira nikal na ....". Vese aap ho sir ji
Thank you so much... One big problem of mine solved.
Very nice, easy and shortest yet amazing video.
But I don't want pivot with different sheet. Please could you help me in it?
If you add a new column in the split excel sheets, what should you do to get to the main sheet?
Ek doubt hai Jo aapne master sheet pe table banaya us table extra details add kaise karein aur mein ek baat aur puch Raha tha jadi ye sab party mein Naya party add karta hun toh uska sheet kaise create hoga
बहुत बहुत धन्येवाद🙏
Sirji........ easy & totally understand secret tips....wow.
Sir one query :- " aap ka ye same data me muje party wise konsi party ke kitne invoice bane he vo Jan na he ek simple se deskboard pe show karvana he to kese kare..........???
" Jese ki me deskboard pe koi party ka Name search karu to vo fast way me......count karke de.............???.
Is se smart work bhi hoga or Boss ka dil bhi Jit lege........🤗
Please requested sir....... Make it ......
Hie
Can you plz tell me filter vale colum nai new add karna hai to uska new sheet kese generate hoga
What I can do, I need to add 100 people details of Debit and credit,. So what the best method to do that. Which is easy to edit, add ? Please tell or make video
Very Nice Information
Thanks
My data in excel sheet is date wise amd I want to print pages excel sheet,but date wise...means when date changes it comes to next page..help pls
It is dynamic?
I Only want to keep separated data as values not pivot table as in that different sheets when I click on drop-down all values are showing, I do not want to see other that selected filter, any suggestions?
Select all sheets as shown in the video. Copy the pivot table of one sheet without the first row and paste the copied table below the pivot table. Now delete the pivot table and unselect all sheets. You will have the data as simple tables.
But that filter button is still on the sheet so how can we share with separate people because everyone knows how to unhide so they can see our whole Data
Please Help
Sir if i add new party in mastersheet it's automatically create new sheet for new party
Nice video, and I want to make summary of total from all sheets in single sheet
Hi sir......one query hai meri....mere pass ek data means master file hai usme name, mobile no, city, order, pincode,status - Dispatch & Pending hai. muje master file me se Dispatch & Pending file new sheet me Lana hai.dispatch & pending data separate mean new sheet create honi chahiye. Pending & dispatch 2 new sheet create hone ke baad jab measter file me new data add Karu tab wo data status ke jariye pending & dispatch sheet me add hona chahiye automatically....ye query formula or VBA coding ke kaise solve hogi...plz tell me formula or VBA code.
Kuchh hi din me video upload ho jayega
Excellent ....
Thank you! Cheers!
Bro what if the 500 sheet are required excel will not do
50 column h mere pass???
Very nice knowldge
Thanks
जय हो
what if we have multiple transaction in one date. how to show multiple transaction on one date in pivot table.
ab pivot table remove karna ho to kaise karenge
kyuki , pivot table remove karke bhejna hai
nice if need some personal help is it possible sir
Agar old version me ye formula nahi hai to kaise karenge
What to do if you want to add a new party
No analyse option in my excel what if analyse is present. what to do
❤
Nice
New pary add karna hai to kya kare
Sir analyse botton 2010 excel version mei nahindikh raha. Please help
Sir google sheet me kaise karenge
Thank you for this video sir
Thanks 👍 bro
Welcome 👍
Agar pivot table nhi banana
Mtlb koi calculation nhi
Just different sheet me laana ho to
Thanks for this video
New party add karna hai
Thanks
Welcome
Nice and right✌
How to update all sheets
Please share the database prectise sheet
Very interesting
total sum nahi aa raha
Sir where is practice sheet?
Very nice,
Very helpful
THANKS!
You're welcome!
Under analyze....SHOW REPORT FILTER PAGES..IT IS INACTIVE..
That is because you have not put any fields in the FILTER in the Pivot Table.
👍
Itna sab karne koi jarurat nhi hai macros run karo