Dear Deepak, I have watched many of ur video on excel. Made my work easier and started enjoying working on excel. I need a solution from you Can we split files, as we print tiles with repeated column.
Deepak Greetings thank you for teaching very easy way How can i transfer DATA's from one sheet to multiple sheet based on serial number (from serial 1 to 300 one sheet and 301 to 600 another sheet like that0
Hello Sir Sir, Agar kisi workbook me 10 sheets h aur har sheet se mujhe kuchh particular values ko kisi another excel sheet me filter krna h to kaise krenge is pr ek video bna dijiye aur mujhe tag kr dijiye sir taki hm usko sikh sake ......please sir 🙏🙏🙏🙏🙏🙏🙏🙏
Bhai master sheet ko filter laga kr data 2nd sheet mein link Kiya ha. Ab 2nd sheet sheet sy ctral+[ press kr k master sheet k attach data ko view krna cahty hain laken yaah zarori hy k master sheet ka filter data hi show ho bajay iskey k pori master sheet hi show ho or cell number vise track na krna pary.
sir nice one. i want to know agar ek excel file me data entry user form banaya he vba dwara.. macro v he to us file ko banane ke baad.. us file ko dusro ko Cd/ pendrive me kese dena taki he wo apne offline computer me run kar sake sahi tarike se. plz guide.
Agar main after 6 months regular entry ek aur project sheet add Karni ho toh filter all mein saare project sheets aa rahi hai firse... koi aur Tarika hai jisme hum project add Kare toh filter se ek hi sheet add ho toh Naya list me add Kiya ho..is it possible?
Sir I have 1 master data for Vehicle lubricants issue report and every week I add the data in master data through copy paste .. kindly provide simple process..
Hi Sir very good knowledge give by u sir! few querries... how can i add new salesman? once added new sheet will open as before ? if i wan to edit before entries will it update in new its Sheet ? If i missed out entries date wise will it added to sheet date wise? Thanks for reply.
Thanks sir for making this video full of knowledge. I have a question related to this video. if master sheet have 100 salesmen, in this case how can we go to specific salesman sheet in single click than that of going to see sheets one by one. plz help in this problem. and plz must reply
Click on 3 dots try both left and right click there to go specific sheet it will show drop down box u can select from there or u can go direct through that filter where u selected all at the first place if u only wanna analyse the data
Sir Thanks for your support to enhance my excel knowledge. I have a question for this topic if we put sr. No. First how can it will comes serial wise in separate sheet.
Me month wise attendance sheet bana rahi huin.but me chahti huin ki master sheet me jis mahine ki data entry karun wo automatically usi month ki sheet me entry ho jayen wo v without copy me.example me January ka data entry Kiya master sheet me aur me chahti huin ki without copy wo January ke sheet me automatically entry and save ho jaye.Plz help me
Hello, very impressive and knowledgeable video nd very useful too, I have two problems, hope you help me to get rid of my problems 1) i am using windows 7 ultimate, i had trouble in installing Microsoft office (even 97-2003),i had tried everything to make run office in my laptop(compaq 420),but failed to do so, As part of alternate way, i m using WPS, but many feature are not available for me, I am college going student and have to work in field of research work so please help me to get rid of this issue or suggest alternative of msoffice nd wps, i have to work mainly on excel, word nd PowerPoint, looking for early response Thanking you
Hello I'm facing a issue where I added my headers as months in the format mmm-yy but pivot table converted my data to numbers and when I changed it back the sheets made had no name.
very good excel concept , Thank you so much for video
Kya baat h
Thank for your unique teaching style. (Lahore)
This is good way if it's work properly.
I will try it
Thanks Deepak Ji for the explaing in very simple way
Excellent زبردست
Sir I appreciate your unique trick
Sir excellent information to save time
Dhanyawad sir
I am applying this types of pivot table formula.
Nice information, thanks Sirji !
Wow 😳 shandaar trick boss 👍🏻
Really Knowledgeable video Thanks
Excellent work thanks for your teaching very. Thanks
Hyyy❤️
Super 😊😊 master class 🤗 dil se dhanyawad 🙏🚩 Jay shree Ram
Gajab video hai sir
Hyyyyy❤️
Hyyy❤️
Hello sir, it's too good, I really appreciate you, you have to right, I say again & again thanks a lot.
Thankyou for such a thoughtful idea.
Thank You very much for your constant support for the people. You are really helping us a lot. You have increased our knowledge. 🙏
शुक्रिया सर जी
Excellent
Sir amazing..I'm learning a lot from u..🙏🙏🙏
An easy way to creat understanding
Thanks in my heart
Dear Deepak, I have watched many of ur video on excel. Made my work easier and started enjoying working on excel.
I need a solution from you Can we split files, as we print tiles with repeated column.
Please sir insart tab excel video banaiye sir please aap ka video bhut achhe se samjh me aata hai sir
Ap ek genius ho..... 🌈☄️
Dil se thanks 👍
Video Creator + People like me !
Who come to learn something new on UA-cam.😇😇😇🙏
Thanks sir
Hyy
Hii
Kese ho
Deepak
Greetings
thank you for teaching very easy way
How can i transfer DATA's from one sheet to multiple sheet based on serial number (from serial 1 to 300 one sheet and 301 to 600 another sheet like that0
Bahut hi badhiya trick
Superb Trick thanks
Thank you so much
thanks iam looking for this trick thank you very much
I love with excel
Hyyyy❤️
Sir g made such types of video
Hyyyyy
Very helpful
Very well explained
Bro sahi he . Par alag alag sheet ko ek sheet me kese kare ? Please share idea
Very good teaching sir
Superb sir
LOVE YOU SIR
Proud on you sir g
sir aap ek VS code ka tutorial banao please 🙏🙏🙏🙏🙏
Very useful video sir, agar hume multiple sheets me se ek master sheet banani h toh kaise karenge pls bataye?
hi,sir after making this table and sheets, if i add new costumer or any column ,kaise unki sheet banegi
Hello Sir
Sir, Agar kisi workbook me 10 sheets h aur har sheet se mujhe kuchh particular values ko kisi another excel sheet me filter krna h to kaise krenge is pr ek video bna dijiye aur mujhe tag kr dijiye sir taki hm usko sikh sake ......please sir
🙏🙏🙏🙏🙏🙏🙏🙏
data entry production ki ek jgh entry krk in out alg alg sheet m kaise entry kaise krain
Excel me insart tabe ka video banaiye sir
Bhai master sheet ko filter laga kr data 2nd sheet mein link Kiya ha. Ab 2nd sheet sheet sy ctral+[ press kr k master sheet k attach data ko view krna cahty hain laken yaah zarori hy k master sheet ka filter data hi show ho bajay iskey k pori master sheet hi show ho or cell number vise track na krna pary.
sir nice one. i want to know agar ek excel file me data entry user form banaya he vba dwara.. macro v he to us file ko banane ke baad.. us file ko dusro ko Cd/ pendrive me kese dena taki he wo apne offline computer me run kar sake sahi tarike se. plz guide.
Wow Work is very easy
NICE ONE
Hi my dear sir thank
Hyyy❤️
Hyyyy❤️
Dear sir
Kya ye option excel 2007 me v available hai??
Thank you
Video was magical...thank you Sirji
Nice 👍
Agar main after 6 months regular entry ek aur project sheet add Karni ho toh filter all mein saare project sheets aa rahi hai firse... koi aur Tarika hai jisme hum project add Kare toh filter se ek hi sheet add ho toh Naya list me add Kiya ho..is it possible?
Sir I need merge of different sheets in master data as not combine or Power Query.i.e row wise
Kaam ho gya sir aapka
@@563abhinav no
Great
Hyyy❤️
@@officialshanu3496 yes
!!! Thanks a lot ...☺️☺️
Sir one excel sheet data se hum chuno hua logo ki data kese alag ek sheet per le sakta hain with out copy
Thanks to Much sir....
If i enter salesmen E details in master deta will it send to another sheet.
Sir Excel ka please complete tutorial dijiyega one video pe?
Hyyy❤️
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Sir I have 1 master data for Vehicle lubricants issue report and every week I add the data in master data through copy paste .. kindly provide simple process..
Brilliant 👍🇵🇰🌺🌷🌹💐♥️🌸
THANKS
Hi Sir
very good knowledge give by u sir!
few querries...
how can i add new salesman? once added new sheet will open as before ?
if i wan to edit before entries will it update in new its Sheet ?
If i missed out entries date wise will it added to sheet date wise?
Thanks for reply.
Very knowledgeable video Sir
After a long time… i m reading your comment 😊
Sir kio job advance excel ke lye batoo sir
Thank sir how to make master sheet from different sheets that means per day
only min,max, average in same workbook.
Sir mera Kam accounts ka Hy
Mujhy kuch problem a rhi hy exel py
Ap kuch help kr sakty hain ?
sir jese aap ne sir ms word ki video bna rkhi vese hi ms excel ki bna do sir pkease sir
very nice
Sir beginner bala batch continuous kijiya na please
New video jaldi aayega A To Z pe
Hyyy❤️
❤️🔥💯
👌
kya sir jese home ab phir tnterst tab phir pagleyout tab fromule tab view en ki ek video bna do aap aacha krte ho sir please sir
Thanks sir for making this video full of knowledge. I have a question related to this video. if master sheet have 100 salesmen, in this case how can we go to specific salesman sheet in single click than that of going to see sheets one by one.
plz help in this problem. and plz must reply
Click on 3 dots try both left and right click there to go specific sheet it will show drop down box u can select from there or u can go direct through that filter where u selected all at the first place if u only wanna analyse the data
Mere pas excel 07 hai usme nhi a rha pivot table analyse ka option
How can I down load samples of master date for making dash boards?
Hello sir, Shopping mall per Excel main kya Kya kya kam karna parta hain. Ek Complete Video Playlist Banayega. Please Sir.....🙏😊🤗🙏
Sir Thanks for your support to enhance my excel knowledge.
I have a question for this topic if we put sr. No. First how can it will comes serial wise in separate sheet.
I love your work
Hyyy
Nice
Before making pratise of your lecture our most time is waisted to make practise data or table there fore data should also be provided. Thanks
Me month wise attendance sheet bana rahi huin.but me chahti huin ki master sheet me jis mahine ki data entry karun wo automatically usi month ki sheet me entry ho jayen wo v without copy me.example me January ka data entry Kiya master sheet me aur me chahti huin ki without copy wo January ke sheet me automatically entry and save ho jaye.Plz help me
Sir this technica can use bangla data??
Me hon depak... Ap ka dost... Lets begin this TOPIC....
Hello, very impressive and knowledgeable video nd very useful too,
I have two problems, hope you help me to get rid of my problems
1) i am using windows 7 ultimate, i had trouble in installing Microsoft office (even 97-2003),i had tried everything to make run office in my laptop(compaq 420),but failed to do so,
As part of alternate way, i m using WPS, but many feature are not available for me,
I am college going student and have to work in field of research work so please help me to get rid of this issue or suggest alternative of msoffice nd wps, i have to work mainly on excel, word nd PowerPoint, looking for early response
Thanking you
If i want to add a record with new name , new sheet will be added ?
Sir y function WPS m kaam kyu ni kar raha usme pivot report analysis tool show ni ho raha...sir please help
Kudus to you man
Sir koi part time job h student ke liye jaha wo 2 ya 4 hour. Kaam karke apna pocket kharch nikal sake aur padhai bhi krta rhe
Hello
I'm facing a issue where I added my headers as months in the format mmm-yy but pivot table converted my data to numbers and when I changed it back the sheets made had no name.
Can we this data in the same sheet
Bahut hi saral shabdon mein .Mere paas shabd nahi hein . aabhar