Excel - Split Master Spreadsheet Into Multiple Sheets With one click without VBA

[rldb]

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.

[indianmonster]

I like to thinking about this bolte hena "dariya mese hira nikal na ....". Vese aap ho sir ji

[tanvirahammed]

Thank you so much... One big problem of mine solved.

[indianmonster]

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

" Jese ki me deskboard pe koi party ka Name search karu to vo fast way karke

Is se smart work bhi hoga or Boss ka dil bhi Jit

Please requested Make it

[abduljaleelpanthakkan]

If you add a new column in the split excel sheets, what should you do to get to the main sheet?

[bholebaba]

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

[varshasharma]

But I don't want pivot with different sheet. Please could you help me in it?

[khushbushah]

Hie
Can you plz tell me filter vale colum nai new add karna hai to uska new sheet kese generate hoga

[mohanjoshi]

Very nice, easy and shortest yet amazing video.

[StechEarnings]

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

[pankajkumar-jhic]

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

[adnanansari]

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

[amitkasare]

Hi 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.

[aarshinpanchal]

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?

[mukeshkumarmehta]

What to do if you want to add a new party

[saifrashid]

what if we have multiple transaction in one date. how to show multiple transaction on one date in pivot table.

[bharatnautiyal]

Bro what if the 500 sheet are required excel will not do

[bkrahulprasadsingh]

ab pivot table remove karna ho to kaise karenge
kyuki, pivot table remove karke bhejna hai

[brajeshdwivedi]

Agar old version me ye formula nahi hai to kaise karenge

[riazkhan]

Sir if i add new party in mastersheet it's automatically create new sheet for new party