@@EasyExplain When you shift the name column to the left, the job title column automatically got disappeared. I have a doubt here. Did you delete that column? Because when you applied same thing with Gender, the result was different from the previous one.
Guys i dont know why this guy is not getting likes and subscription , You Nailed it my bro ... My request please keep continue with excels expertise in easy way .. I learned a lot ... Thanks a lot
Thanku so much macro k video to bahut se logo n bna rkhe h bt save krne ka jo tarika aap n btya bahut hi excellent he. Really good video again thanks sir.
Amazing video, example of recorder was osm👍 I was searching for a video where I can hide/unhide rows through toggle,have you made any such video? Please share.thanks alot
@@EasyExplain Cleared CHSL 19 waiting for descriptive result and waiting for NTPC result....But I don't want to wait bro.... Bro give me tips to start a career as data analyst
Hello @easyexplain Can you please tell me how can I get default view of vba in excel when creating macros because by mistake I have clicked some options and now it is showing only blank screen.
Hi Sir, At first, I appreciate ur struggle and secondly i have one question, once i record the macro suppose for 10 lines formatting in excel sheet and it saved. But in next time, if I have the data spreading more than 10 lines i-e 50 lines in excel sheet, how macro will work for formatting of 50 lines if I run it as previously saved?
No it won't work. You need to add some formulas too if you are not sure about the line (10/20 or may be 50) for the next time . Reach me on exceladvisoor@gmail.com for help.
Thank you for this video. Can you also do video for Loop by using same data. In this we have only 10 line of items, if there is more data and we need to apply same formatting, how we need to do this. But we have recorded macro only for 10 line of items.
Thank you, I have a doubt, in this macro only you have used only 12 row, if we next report row increase, like 50 or 100, this macro work or not. Please confirm.
Just tell me one thing.suppose this data is for the month of January.What if I want to use Macro for the data of Feb n March? Do I have to record Macro again? Or simply a Run macro will do? Plz help me with a solution. Thanks🙂
Sir ap please ak formula bataiye . Ki excel ki first sheet mai agar date wise entry kare or us entry ke piche yadi koi code ya no. Dal de yadi to us related next sheet column mai wo entry kya chali jayegi
Can you please show how can we combine multiple excel files to multiple excel sheets of single excel file using maco..like if we have 50 excel files to be combined to 50 excel sheets of single excel file..is it possiblle in macro?
Excellent way of explaining every step, i'am from Pakistan, it looks you're telling in urdu, very little use of typical and difficult words from hindi. I loved it. Full marks bro
Very nice sir, but I have a question if I want to apply the same formatting macro on the same type of data but the data has a few more rows then how to do that? because then the macro is not working on the extra rows . Please suggest the process.
Good but when the raw data changed how to apply in new sheet is it required copy the data from the new one and paste and then apply macros ? how is will useful when tha raw data changed
Sir kya har file k liye ise aisa Krna pdega to fir fayda kya hoga itna krke... suppose koi dusra data aaya r usko simplify Krna h aise hi to uska b aese hi macro file bna k run Krna pdega...to same hard work ho gya na
Kya samjhya hai sir ..🙏🙏🙏 mne bht vdo dekha h pahle is topic par lekin aapka jabab nhi..tnqqq..or advance leble pay batayega...plzz
Arey vaah. Jarur.❤️👍🏻😊
Mai jo payment bolenge vo payment krwa denge.
@@EasyExplain When you shift the name column to the left, the job title column automatically got disappeared. I have a doubt here. Did you delete that column? Because when you applied same thing with Gender, the result was different from the previous one.
9
@@simransurve1644 because i think he pasted the name column and gendee column was cut and insert plus
Guys i dont know why this guy is not getting likes and subscription , You Nailed it my bro ... My request please keep continue with excels expertise in easy way .. I learned a lot ... Thanks a lot
You're Welcome Brother. Thanks For Your Support. Keep Loving Keep Sharing 👍🏻❤️.
Excellent way to explain... I had seen many videos, but none was at par with yours... Kudos!!! & Thanks
Arey kyaa baat hai.. I didn't realize how well I would understand these macros in the Hindi version ❤
Thanku so much macro k video to bahut se logo n bna rkhe h bt save krne ka jo tarika aap n btya bahut hi excellent he. Really good video again thanks sir.
Bahut dino ke baad ap ka video dekhne ka mauka mila
Wow.. explained so sleekly...you are a great teacher..thanks for the helpful video..
Best video I have ever watched. Thank you so much.
Thanks
Bahut badhiya pehli baar maine ek macro record kiya bhale hi tuccha tha but tha macro thnx dost
😂👍🏻
Very thank you
There was a big confusion in this topic. Thank you for solving
Thank you sir, simple and clear explanation 🙏
You're Welcome. Keep Sharing 🔃
Thanks bhai month end pe Mera kaafi kaam easy hogayaa
I never thought to create macro is so much easy. Thank-you
Amazing video, example of recorder was osm👍 I was searching for a video where I can hide/unhide rows through toggle,have you made any such video? Please share.thanks alot
You are doing such a great job you make every complex lecture easy for us
Sir where is job title coloumn after shifting...
Short, simple and crips! Great information, thank you so much!
can you pls explain me 9570665777
Thank you for clear understanding
Sir you are superb... You explain with so clarity that anyone can learn it very easily... Please make more such videos thank you
Thank you for this video. It is very useful in working of MS excell.
Briefly and perfectly explained. You have gained a new subscriber from Pakistan. Thank you.
Ek number sir! short, simple and directly explain! super sir. pls continue more topics.
Ur way of. Medium is so easy and fantastic sir.. love u
Keep Sharing 🔃♥️👍🏻
Thank you sir I love your teaching way
Thanks sir to excel in a simple way
this is excellent, the way you taught is very exceptional. thanks brother
Shandar jabardast jindabad kya samjhaya hai sir aapne Thanks a lot
You're welcome. Keep Sharing 🔃♥️👍🏻
Can we record PIVOT TABLES AND VLOOKUPS in macros?
wav,,, superb informative video.. if we get explained like this during our studying time kaha rehte ham.. thank you so much..became your fan
Glad To Hear that. Definitely you can be wherever you want to even today if start focusing. Keep Loving Keep Sharing 🔃♥️👍🏻
This video is so helpful for me thank you sir 🥰
Just loved the content.... Let me go back n start building the Macros 🙂😀
I came here after watching 4 videos before...very well and easy explained...Keep making such videos...
You're welcome. Keep Sharing 🔃♥️👍🏻
awesome easy very easy thank you so much....
I will recommend this to everyone In my team, thanks
You're welcome. Keep Loving♥️ Keep Sharing🔃
Where you work bro??
@@thefunland2481 it seems like you are from U.P. and were preparing for SSC exams and Railway exams. How did it go?🙂
@@EasyExplain Cleared CHSL 19 waiting for descriptive result and waiting for NTPC result....But I don't want to wait bro.... Bro give me tips to start a career as data analyst
Very simple and easy to understand video.
Aapka samjhane ka tariqa lajawab sab se hat kar
Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU
Maja aa gaya yaar. Seekh gaya main. Kaam asaan ho gaya
Nice way to explain..Easily understanding
Thanks Buddy. It was very useful for novice to understand.
Simply great explanation.. you have done this very easily understandable..👏
Hello @easyexplain
Can you please tell me how can I get default view of vba in excel when creating macros because by mistake I have clicked some options and now it is showing only blank screen.
Can we record countif, concatenate, vlookup, pivot functions in macros.
Wah G wah Akkash Gujjar
I'm from Pakistan also Gurjar or Gujjar. Great teaching❣
Have exams tommorow you saved me thank you
Love i bro time bahut save ho gaya
Thank you for this video. Can we add pivot table. Mcros not performing my pivot step
Bohat Awlaa Bhai Shukria..
Thank you so much sir.
Muje poochna ta ki is me vlookup ya hlookup laga sakte he
Hi Sir,
At first, I appreciate ur struggle and secondly i have one question, once i record the macro suppose for 10 lines formatting in excel sheet and it saved. But in next time, if I have the data spreading more than 10 lines i-e 50 lines in excel sheet, how macro will work for formatting of 50 lines if I run it as previously saved?
No it won't work. You need to add some formulas too if you are not sure about the line (10/20 or may be 50) for the next time . Reach me on exceladvisoor@gmail.com for help.
Perfect explanation, thanks
Amazing ! Thank you for this tutorial.
You're Welcome. Keep Sharing 🔃
excelent video.
Thank u Brother u taught it in a very correct and decent way i like it very much
You're welcome. Keep Sharing 🔃♥️👍🏻
Macro ke liye bahut achcha banaya hai aapane aur Maine use bhi Kiya hai Lekin hamen ek Aisa micro chahie
Good explanation of the topic!
Nice video...great way of explaining..
thanks for beautiful video
Loved it... Learnt a lot of new stuffs
super sir. nice teaching 👋
Now understood, agar mouse ki jagah saare shortcuts key use kre to records hogi?
thank you brother explanation alhamdulilah
Thank you for this video. Can you also do video for Loop by using same data.
In this we have only 10 line of items, if there is more data and we need to apply same formatting, how we need to do this. But we have recorded macro only for 10 line of items.
You need to select all the data. as per my knowledge volume will not be a constraint
Google sheet me macros kaise use karna hai ispe bhi ek series banao na aap please
Sir jese mujhe new wali mili hai us par micro lagana hai to kya new record karna padega har bar ya ek hi mocro lagega
Vlookup with different sheet kaisa macros mai banane ka plz batai sir ek video banao sir
Thank you, I have a doubt, in this macro only you have used only 12 row, if we next report row increase, like 50 or 100, this macro work or not. Please confirm.
Just tell me one thing.suppose this data is for the month of January.What if I want to use Macro for the data of Feb n March?
Do I have to record Macro again?
Or simply a Run macro will do?
Plz help me with a solution.
Thanks🙂
Same question i have , can i use recorded macro for next day Pendency report
If rows or columns both are increases or decreased do same micro will work
Thank you frnd superb explanation ❤️
You're welcome. Keep Sharing 🔃♥️👍🏻
Sir form se row me data entry hoti hain column me entry karne ke liye kya kare
So well explained in detail
Mast samjhaya
Nicely explained very cool and calm way.Thank you Sir.
Thank you love to you
Please insert more vedio about macro and devlapor
Thank You So Much 🙏🙏
Nice video.. easy to use for daily work
Kya ek baar macro record karne ke baad uske function koi bhi nayi file main use lar sakte hai ?
Sir ap please ak formula bataiye .
Ki excel ki first sheet mai agar date wise entry kare or us entry ke piche yadi koi code ya no. Dal de yadi to us related next sheet column mai wo entry kya chali jayegi
Can you please show how can we combine multiple excel files to multiple excel sheets of single excel file using maco..like if we have 50 excel files to be combined to 50 excel sheets of single excel file..is it possiblle in macro?
Thank u so much Sir 🙏
Very clear.
Excellent way of explaining every step, i'am from Pakistan, it looks you're telling in urdu, very little use of typical and difficult words from hindi. I loved it. Full marks bro
Their is no such language URDU
Great information
Agar ham raw data m Naya data dale ek bar macro record Karne ke Baad to Kya macros run Karne ke Baad Naya data us format m Milega???
Thank you so much 🥰
Very nice sir, but I have a question if I want to apply the same formatting macro on the same type of data but the data has a few more rows then how to do that? because then the macro is not working on the extra rows . Please suggest the process.
superb video..cleared in one shot.
Also learn excel vba course in urdu
Very well explained, Great going!
Best for Easily learn thanks
Most welcome
Sir macro sirf 1 sheet pe hi hoga ya 2nd sheet pe koi data copy past kare to uspe bhi apply hoga .
Good
but when the raw data changed how to apply in new sheet
is it required copy the data from the new one and paste and then apply macros ?
how is will useful when tha raw data changed
It was really easy to understand thanks
Easily explained. Thnx
Can we use look up from other sheet and record macro and make summary
Hello! Can you please post a video on how to create KPI Dashboard using Excel?
Best Video.
👍👍👍👍👍
Can you pls prepare video on S Curve..????
Thanks sir
Very easy explanation
Keep it up .....
Will sure do. Keep Loving. Keep Sharing.👍🏻❤️
Also learn excel vba course
Nice explaination
Bro u r a superhero in excel
In Explanation. 😘
Sir kya har file k liye ise aisa Krna pdega to fir fayda kya hoga itna krke... suppose koi dusra data aaya r usko simplify Krna h aise hi to uska b aese hi macro file bna k run Krna pdega...to same hard work ho gya na