Split Data from a Master Sheet into Several Worksheets in Excel without Macros

[@MyLiveSupport]

New Party का डाटा कैसे Split होगा ? ये वीडियो देखो kzbin.info/www/bejne/fInIkpmdq8xlrpY 🥰🤗 Get Complete Excel Course - www.mylivesupport.in/

[@pravinnandrekar7268]

Congratulations very good subjection

[@MyLiveSupport]

Thank you sir😄🙏🙏

[@remarks7607]

Jinke pass purana office hai oh kya karen

[@MyLiveSupport]

उनके लिए भी यही तरीका काम आएगा

[@ateeqahd]

Osm thanks

[@neelakshishrirao8173]

Bahot Accha Laga Bahot Jankari Mili

[@MyLiveSupport]

thank you so much

[@girishdedakia582]

Very nicely explain. Very useful video.👍👍

[@sandip1562]

Dipli mein dekhne ko bahut kam milta hai very nice sir

[@ykv1971]

Excellent. Amazing 👌👌👌👌👌

[@sandyyadav8595]

Super duper 👌👌 very helpful

[@MyLiveSupport]

Thanks 🥰

[@nAJEEbKhan-um9wo]

Good JOb.... Very Nice Video... Thx it helped me alot Thumbsup + Subscribed

[@gangadesh]

Very Nicely Explained. Thanks for the video. Learnt something new.

[@pandavjk547]

Best one great job

[@ranvirvashisht1415]

Really helful mainting records!!!

[@yadveersingh5050]

Bot acha smjhate ho aap sir g

[@SarojMjh]

Jhakas.... Love from Kathmandu, Nepal

[@balwinder3322]

Very useful information

[@purushottampatel4638]

Great sir very nice

[@chauhanatul8535]

Super sir

[@manmohandeol4908]

Good information dear

[@aiyubkhanghasura316]

Superb sir

[@RahulPatil-yo2nr]

What an idea Sirji

[@aiyubkhanghasura316]

Good Info Sir

[@MdIlyasShaikh]

Really helpful hai Sirji. Thank you so much.

[@MyLiveSupport]

Thank you 🤗

[@jk07-jk07]

Knowledgeable video sir....

[@binayyadav1987]

Super super great sir your great contributions

[@MyLiveSupport]

Thanks 🥰💐

[@pravinnandrekar7268]

Congratulations, very good subjection

[@MyLiveSupport]

Thanks 🥰

[@adalathussain6354]

Thanks a lot

[@AdilKhan-lx9dm]

Yes boss really amazing.

[@MyLiveSupport]

Thanks 🥰

[@tiwarinavneet515]

Wonderful sir

[@BalvirSingh-qs9kz]

Sir, very nice. Sir pivot table new workbook me kaise bansakti hai?

[@smitachakraborty6548]

Very helpful video sir nice

[@MyLiveSupport]

Thanks 🥰

[@cyphernetwork4211]

Superb sir Kya master sheet me accending A to Z short karva sakte hai ?

[@pirtpalsingh2324]

Very good teaching.

[@MyLiveSupport]

Thanks 😄🥰

[@mohanjoshi5639]

Nice lesson. Kya isme user form joda ja sakta he?

[@prasannanm5513]

Super sir 👍🙏

[@shankarh6310]

Very useful, thanks Bhai

[@MyLiveSupport]

Most welcome 💐

[@chandramohan1418]

Very useful video sirji.pl make a video on BRS. as per practices followed by CA. i have tried using Pivot table/power query but getting result.thank yu

[@QuantumSolutionsIndia]

Amazing👏

[@pramodbhavsar4488]

Thank you sir very nice idea for pivot table

[@MyLiveSupport]

Most welcome 💐

[@arijeetkumarsharma226]

Superb

[@MyLiveSupport]

Thanks 🥰

[@nivruttibagul638]

Best video

[@meeragaja7879]

super bro

[@PankajKumar-wo2ps]

Thank you

[@MeSouravBairagi]

Wah Sir ji kamal hai....

[@shujaahmed08]

please subscribe me.

[@MyLiveSupport]

Thanks 🥰

[@remarks7607]

Very good

[@MyLiveSupport]

Thanks 🥰

[@neharajput4733]

Wow nice keep going...!!👍

[@MyLiveSupport]

Thanks 😄💐

[@padamshrestha42]

Good & useful video....

[@MyLiveSupport]

Thank you

[@nikhilgondane]

Life saver

[@amol713]

Informative video sir, Sir agar mai master sheet me text ki jagah new data paste karta hu to kya ho sabhi sheet aata nahi. Any tricks for that problem

[@ShyamranjanSingha]

Very good teaching, enjoyed❤

[@MyLiveSupport]

Thanks 🥰

[@pratibhatambe6171]

Hello sir, video is really nice for split worksheet,need to understand code or what we need to do if I want to add serial no column for each splitted sheet .like for each sheet need need sr no will start from 1

[@adalathussain6354]

can we add other raws as customer name .if yes how we can ?

[@mahmadhusain]

Awesome video 👍 Sirji Agar sheet me new party adding karenge to vo party ki new sheet instant ho jayegi ke nahi hogi ?????

[@MyLiveSupport]

Sir iske liye aapko dobara se pivot table option mein jake same method use karna padega

[@ashokvithlani6827]

मगर सर वो प्रोसिजर करने से बनी हुई शीट भी दुबारा बन जाती है । हेल्प

[@sarvodayaconventvidisha1757]

You r great sir

[@MyLiveSupport]

Thanks 🥰

[@h.s1406]

Sir aap VBA basic se sika sakte ha kya ....

[@mukhopadhyaysomadatt]

If I want to include new party name then filter column should be updated I think. Please confirm.

[@MyLiveSupport]

Read first comment

[@bobbybobby3276]

Thank you for valuable and smart techniques. I have doubt if we want add new party will automatically creates another sheet or need to continue from starting point process. Please clarify

[@MyLiveSupport]

i will make a separate video on that topic.

[@suzenpaul9258]

No the party name not updated automatically.

[@technicalandearningsspecia6049]

Best

[@MyLiveSupport]

Thanks

[@crazysanam]

Bhaisaab master sheet jaise aapne banaya use kaise banaye..visatar se abatye

[@alndr4u]

Sir maine aisa hi kuch table banaya h koi 15 pivot tables aur charts banaye h to mera xlsm sheet 150mg ka bna h isko, chote size me bnana h to kaise kare...

[@mirzafarhanbaig8592]

Ma Sha ALLHA bohat zabardast mujy kuch or Upsate Chaye Like aap ne data to entry karli hai ab party se payment bhi ajati hai to ek Cr ka colum ho jo k Dr or Cr kary or dr cr ho kar balance Show ho

[@wajidhussain5750]

Hello .... please help me how can i put value by a sheet list to every cell across worksheet ?

[@janankhan6888]

very well

[@MyLiveSupport]

Thanks 🥰

[@mr.awesome23]

Very Good bro

[@shujaahmed08]

please subsctibe me

[@MyLiveSupport]

Thanks bro

[@harishtote9573]

Very interesting

[@MyLiveSupport]

Thanks 🥰

[@neelneel4899]

Agar ham master me jo name nahi he wo enter karege to woh new name ki sheets bhi automatically ban jayegi?

[@bioworldhyd]

good

[@utkrishtafashionhouse]

Great

[@faiyazmuhammadqasim1547]

If I want to add more suuplier in master sheet, then how new supplier can be added automatically in pivot table...?

[@ghanshyammistry6502]

Nice

[@MyLiveSupport]

Thanks

[@uttamyadav4431]

Awesome

[@MyLiveSupport]

Thanks 🥰

[@dineshkumardsds8069]

🙏🙏

[@inderjitsingh9717]

Sir jekar master sheet vicho koi row delete karni hai ta duji sheet cho v delete hovegi

[@MyLiveSupport]

Sir try karke dekho ek baar

[@amit2loveu]

Hovegi 22ji

[@class10study76]

Window 7. M apply hoga kya

[@shahidSag]

Hey!I want to write a program please help me, I have a data (202057-FLC123-shahid) so basically the first part is year-month-date and second part is the filename (FLC123) my main concept to write a pgrm is based on the year-month-date I want to create a sheets ,one sheet1 to put this (202057-FLC123-shahid) address and 2nd sheets2 with dates coloum If we put data in first sheet it should show in 2nd sheet to corresponding date Is it possible

[@subhashpatel997]

👌👌👌👌

[@sumeetmahadani6042]

Sir, agar koi bill entry krne me miss ho gaya 4th Jan ka,aur hum July ke baad entry krte hai,toh kya aisa kuch trick hai ki jaise hum 5 July ko entry krte hai 4th Jan ke bill ka par wo automatically aa jaye 3rd Jan ke bill ke baad aa jaaye..plzzz help me sir..

[@sachinshinde5997]

Very nice sir... Agar muze 3 party name add Karna hai...vo Hoga kya aur nayee entry update hogi kya.. please reply...

[@MyLiveSupport]

Sir sab kuchh hoga agar aap tarike se kaam karein to

[@sachinshinde5997]

@@MyLiveSupport thank you sir... Kaise Karne Ka? Please explain.....

[@vatsaltjib]

Sir agar ek extra name add kiya to uski seperation alag se nai ho shakti.??? Show report filter pages karte hai to baki already bani hui hai wo bhi 2nd time generate ho jaati hai..

[@DataLearninghub]

Yes you're right... Through pivot it happens.. you can use this.. kzbin.info/www/bejne/nZithJJ5ntGMmbc

[@rajendramehra4651]

Nice video sir. Sir ms words kaa short curt button kya hoga..jaise excel mai. Window=r hota hai to Ms words kaa kya hoga please reply sir...

[@MyLiveSupport]

Ms word ka shortcut apko banana padega

[@rajendramehra4651]

@@MyLiveSupport ok sir Sir please 1k video shoot kijiyega jo auto update ho subtract and addition mai 1k page mai karo aur har page mai automatically update ho Jaye sir

[@MyLiveSupport]

Sar aap apne data ko ek table format mein convert kariye iska shortcut hai Ctrl + T Aisa karne se aap jitne bhi formula apply karenge vah sabhi automatic update hote rahenge, इस वीडियो में भी मैंने बताया है कि किस तरह हम टेबल फॉर्मेट में कन्वर्ट कर सकते हैं

[@rajendramehra4651]

@@MyLiveSupport Sir please link send kar dijiyega badi mehrbaani hogi...

[@MyLiveSupport]

Is video mein bhi bataya hai table format mein convert karna

[@bdrajput1]

Sir, Master sheet me nahi party add nahi ho rahi hai. Mere pas excel 2007 hai.

[@jameelahmed5267]

how can we add new customer in sheet after saving the whole split data

[@viveckdutt1970]

Please how can we add new party name and what about payment options?

[@manishwaghe3211]

👍

[@mohammedhussainchinwala3317]

Good

[@MyLiveSupport]

Thanks

[@satpalkatyal9950]

Sir, how new sheet will be inserted for new customer/party name

[@lalitmohansharma468]

Sir, in excel 2007 analyze tab not showing so where to go to find or add this

[@lalitmohansharma468]

ok find now

[@satpalkatyal9950]

Click Options tab

[@satishmolankar4217]

Excel app mein find and replace kaise use karte hain

[@ronakshah4618]

How I creat party name and Item wise both type of sheet in excell book ?

[@mohammadirfankhan6484]

Sir my data are not transferring other sheets.how can be it?? Plz sir help me

[@narendrapala5532]

Worksheets will auto create in same workbook, but in reality we have to prepare separate excel file so is there any trick for that?

[@pirtpalsingh2324]

Kya new party ki entry Karen par bhi new sheet banegi ?

[@shujaahmed08]

subscribe my channel please

[@sandeepzaildar8019]

Hello bro, how we can make a sheet of desired data from a master sheet if we make change in master sheet it also change in required sheet. Example- If we insert a column in master sheet it should be in desired sheet. Please tell simple and effective formula please.

[@mukeshkumarmehta158]

Isme new party add karna hai to

[@nawabraja8]

Agar new party add krna hoga to kaise karenge

[@mayurbakale]

Sirji analyse tab kaise layege

[@MyLiveSupport]

Wo apne aap aayega jab aap pivot table banayenge

[@ankitrawat4299]

How to create new sheet in master sheet

[@sandeepmalhotra7660]

Dear sir, practice sheet download ni ho rahi. Please ise activate kar dijiye.

[@vishnupatel3276]

Isme aur party add karna he to kaise kare

[@ashutoshkaslikar1695]

Analyse tab konse version me aata hai

[@MyLiveSupport]

Sir jab aap pivot table banayenge tab ye automatically aa jayega

[@RamKumar-tc1qh]

How to add new party name? Please tell me it is very important for me

[@merokanhaiya214]

Kya ham is excel workbook ko kisi ko mail kar sakte hain

[@shripaljain8024]

Sir master sheet Mai Qty,rate likhne kye bad Gst or total automatic NHI aa Raha hai

[@MyLiveSupport]

Apne table format mein convert kiya

[@shripaljain8024]

Abh esye thik kyesye Karu

[@shripaljain8024]

Ha table format Mai convert Kiya