Fully clear 😀 how to record a dynamic macro. Thanks a lot my learning of VBA again started. Actually I was waiting of this video from last 1 month. But please don't delay to uploading next video of VBA . its my humble request to you. Thanks Dil se ❤️
Pehle to thank you so much Sir 👏. Kaise ho Sir aap? Aaj bahut dino ke baad aapke darshan huye. Aapke videos dekh ke bahut kuch sikh liya or bhi sikh rahe hai. Outlook se micro ke jariye mail kaise send karte hai vo bhi alag alag client ko iske upar bhi 1 video banao plz
@@Innozant sir I sent you a mail regarding calculating time gap if time is given in UTC format I also shared a sheet naming (manifest pending xlxs) plz sir solve my problem & plz reply to mee
Sir, Mere pass daily ik sheet download hoti hai humare dashboard se. Phir daily ik jaisa work kerna hota hai, jaise b coloum mein numeric data hota hai jo 12 number se jyada hota hai to usko theek kerna hota hai, poree sheet ko trim aur proper case mein kerna hota hai. Jis ke liye mujhe dikkat hoti hai main column inset krke trim aur proper ka formula laga ke ker ya huun . iske liye koi aisa option hai ki poore sheet trim aur proper case mein ho jaye.
@@prashanttyagi1156 bhai 1 tarika hai jisse jitna bhi sheets ho ya jo kuch bhi kisi ko bhi 1 second mein proper,lower,upper and trim ye sab kar sakte hai ....
Sir I pls need a answer regarding this vedio can you pls answer??? Isme aapne dynamic macro ke liye jo ctrl + shift + down aero key kaha he select karna he wo selection kab karna he???
Hello sir first of all good mrning to u nd i m big fan of u .Your way of teaching is very uniqe thats what bring me here .sir how i can get a entry level MIS job i have knowledge of excel and advanced excel please helpe sir
Thanks..if you are confident in advanced Excel kindly prepare your cv based on mis reporting jobs and start applying for Entry level jobs also start learning SQL. And other tools
I want to learn complete VBA Macro. Can you please upload a complete video on VBA Macro ao i can learn it easily and in one go. Really appreciate your work Sir🤍
Sir Mein Mastering excel video course liya hain (21 July) ,agar mujhe koi query hoti hai to kaise resolve kar sakta (aap tak kaise share kar sakta hun)
@innozantofficial telegram id hai use sir direct handle karte hain saath hi monthly Doubt session attend kar sakte hain aap,For more information contact Team Innozant
Thanks Altaf..Keep learning..aap students ke comment par respond karte hai ye apke positive aur knowledge spreading attitude ko show karta hai..Good job ..keep exploring
Yes and no both are...and it depends and vary frok organization to organisation But apko comm skills par utna hi mehnat karna hai jitna technical skills par
Sir, Macro को और अधिक describe करे, ऑफिस use में कैसे ले इसे l मेरे साथ बहुत परेसानी आती है ऑफिस में work करते समय, report बनाते समय, बहुत समय lag, जाता है, दिनभर का processing data को consolidate करके, pivot table लगाकर रोज report बनानी पड़ती है, कृपया मार्गदर्शन करे l Macro Record करने में please apki help चाहिए l दूसरा problem है कि, morning मे सबको Allocation होती है सभी processors को data, सबका नाम रहता उसमे, और बहुत सी columns भी होती है, उसमे से सिर्फ अपने नाम का data filter लगाकर copy paste करना पड़ता अलग sheet पर, फिर vendor wise कुल कितने bills मिले हैं process करने के लिए उसके लिए countif formula लगाना पड़ता है, फिर एक दो comulns भी जोड़ना पड़ता है, उसमे voucher number लिखने के लिए, इतना सारा काम रोज रोज same way मे करना पड़ता है, गधा जैसे, कृपया मार्गदर्शन करे l I want to become expert, An Pro Excel Operator, so need to be your attention please help me sir please 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@@mayurrajude VBA code bahut hi easy hai Yadi aap JavaScript shikhe hai to VBA code sikhana bahut hi easy hai Aur JavaScript nahi shikhe hai phir kar sakte hai but starting me aapko thoda problem ho sakta hai Esme only aapko property method aur eske syntax ko yad rakhna hai
Chandan ji lagta hai first time channel visit kiya hai apne Innozant,Pehli baat maine aaj tak Subscription ke liye kbhi channel par nhi bola hai ,dusri baat Complete course in sequence step by step premium content FREE me padhya hai jo koi nhi padhata,Ek baar dhnage videos playlis dekhne,Na apko subscription lene ki jarurat hai na ek rupye apne kharch karne ki aur aap seekh nhi ache se knowledge gain krenge wo bhi bina ek Paisa lgaye is baat ki bhi guarantee. Keep Learning..Keep Exploring. Apko statment jayaj hai ..Thagaye hue insaan lag rahe hain aap..😊♥️
Hello dear, God bless your efforts. I am a totally newbie vba learner. I come to play with that code and have a simple enquiry. How could i amend this code so that i can return all generated workbooks, inside a folder by which the code is run. Thanks a lot Sub test() Dim rg As Range, i As Long, wb As Workbook Dim vNames As Variant, v As Variant
Set rg = Workbooks("All raw data.csv").Worksheets("All raw data").UsedRange
'get unique names With CreateObject("Scripting.Dictionary") For i = 2 To rg.Rows.Count .Item(rg.Cells(i, 1).Value) = Empty Next i vNames = .keys End With
For Each v In vNames ThisWorkbook.Worksheets("Sheet1").Copy Set wb = ActiveWorkbook wb.SaveAs v, 51 rg.AutoFilter 1, v rg.Offset(1).Columns("A").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 1) rg.Offset(1).Columns("U").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 2) rg.Offset(1).Columns("Q").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 3) wb.Save Next v End Sub
You just need to run this script and you will get the desired result ,If you are asking me to explain the code then unable to explain here as you need to raise a query on @innozantofficial telegram id
Your 1 video i am daily watching 😎your teaching style is good and your smile 😊
Thanks
Dear sir, you Are fabulous, I haven't no words to say more, You are Great and one of the Best RUclipsr Chanal of the Era ❤❤❤ salute to you
Thank you so much 😀 Rohit
Fully clear 😀 how to record a dynamic macro. Thanks a lot my learning of VBA again started. Actually I was waiting of this video from last 1 month. But please don't delay to uploading next video of VBA . its my humble request to you. Thanks Dil se ❤️
Thanks Shubham👍❤️
Thank you sir, you are our inspiration and ray of hope
Thanks
Wow sir superb video very well explain 🙏🏻🙏🏻🙏🏻. Good night
Bahot wait kra diya sir ...tarsa diya tha..wait krra tha kab aaygi next video..
mazaak nahi, isse better kisi ne nahi samjhaya, THANK YOU
Thanks dear
Excellent basic learning of vba macro
Thanks Suresh Ji
Thank You sir for making our work easy.
Pehle to thank you so much Sir 👏. Kaise ho Sir aap?
Aaj bahut dino ke baad aapke darshan huye. Aapke videos dekh ke bahut kuch sikh liya or bhi sikh rahe hai.
Outlook se micro ke jariye mail kaise send karte hai vo bhi alag alag client ko iske upar bhi 1 video banao plz
thanks you so much sir please share more video VBA playlist
Sir plz post 3 to 4 videos in a week🥺.....and thank u for your motivation 😍
Lack of time is issue dear due to other responsibilities
@@Innozant sir I sent you a mail regarding calculating time gap if time is given in UTC format I also shared a sheet naming (manifest pending xlxs) plz sir solve my problem & plz reply to mee
Sir,
Mere pass daily ik sheet download hoti hai humare dashboard se. Phir daily ik jaisa work kerna hota hai, jaise b coloum mein numeric data hota hai jo 12 number se jyada hota hai to usko theek kerna hota hai, poree sheet ko trim aur proper case mein kerna hota hai. Jis ke liye mujhe dikkat hoti hai main column inset krke trim aur proper ka formula laga ke ker ya huun . iske liye koi aisa option hai ki poore sheet trim aur proper case mein ho jaye.
@@prashanttyagi1156 bhai 1 tarika hai jisse jitna bhi sheets ho ya jo kuch bhi kisi ko bhi 1 second mein proper,lower,upper and trim ye sab kar sakte hai ....
Sirrr aap sabse alag hai
Thanks Ritesh ji
nice content
Superb sir
Sir I pls need a answer regarding this vedio can you pls answer???
Isme aapne dynamic macro ke liye jo ctrl + shift + down aero key kaha he select karna he wo selection kab karna he???
Thank you so much sir for uploading this video 🙏🙏
Thanks Rahul
Thank you sir
Sir last was best 😭😭😭😭😭😭😭😭😭😭😭. Because of last scene for me. 😭😭😭😭😭😭😭.
Thank you sir for all Excel video's. ❤️❤️❤️❤️❤️❤️
Thanks dear.keep learning
Sir dynamic matlab kitni bhi baar data change ho like kam ya jada to ye sabpe kaam karega marco right????
u r the boss
Sir very very thank you...
Thanks jha ji
Hello sir first of all good mrning to u nd i m big fan of u .Your way of teaching is very uniqe thats what bring me here .sir how i can get a entry level MIS job i have knowledge of excel and advanced excel please helpe sir
Thanks..if you are confident in advanced Excel kindly prepare your cv based on mis reporting jobs and start applying for Entry level jobs also start learning SQL. And other tools
I want to learn complete VBA Macro. Can you please upload a complete video on VBA Macro ao i can learn it easily and in one go. Really appreciate your work Sir🤍
I request is heard but in one go not possible you to give at least a week to understand each video.
Thanks a lot sir ❤️🙏
Thanks sir
Thank you 🙏
Hello Dear,
I am trying to fix my macro with dynamic range but facing issues. Can I please contact you
Sir
Agar ek workbook mai alag sheet hai matlab ki agar alag department wise ek hi report banana hai to kya ek 3 sheet select karna padega kya ?
❤❤❤❤ thank you so much
Hi sir,
I need guide., To make macro, i am too near to make, but have one query, I need to contact with you.. if you can, kindly help me sir..
Sir plz make more videos on power bi
Sure dear..
Hi sir. Your way of teaching is awesome👏. Can we talk your online classes sir
Take *
Yes Sanjay kindly connect us for upcoming batches details or you may visit Innozant website
Amazing video
Thanks Shalu..Keep Learning ♥️ and revise learned topic on regular interval
Hi sir please share video dynamic record vba for formulas like v look up
Super
Waiting for next video
Sir Ji me aapse or Aapki video se motivate ho ke Excel Sikh raha hu. Agar mujhe Excel ke base pe job milegi to me aapse milna chahuga. 🙏🙏
Phir to hum sure milenge kyuki apne yadi quit nhi kiya aur seekhte rhe to bhale hi time lag jaye but achi job jaroor milegi apko...Milenge hum 👍❤️
@@Innozant Thanks sir Ji, 👍
Sir good pefomar
Room No.
Classes Roll No.
6C(1-15) = 15
Kya 15 ko automatically calculate kar sakte hain?
Please sir solve it.
Sir plz assist, 2 ya uss sy ziada excel files pr kaisy run kr skty hai macros.
sir please share real world project end to end of power bi
🙏🏼🙏🏼
Can we record and use macro on pivot tables
yes but I recommend you to create it through proper vba code not recording
sir
i wanna make a dashboard by using pivot and record a macro but it always shows a error
Sir ji 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Babbaal sir🙏
Thanks Arjun
Sir power bi ka series thoda jaldi bnayiye sir
Sir aapke bharose jee rha hu, thoda jaldi bna dijiye
Thanks...Dear kam time milta hai due to other responsibilities isliye slow aa rhe hain video's
Great Sir
Thanks Abhishek ji
@@Innozant Your welcome sir🙂🙂🙂
Nice 👌👌❤️
How to faxible selection
Sir please post more videos of VBA and macro ..
Sure dear
Macro ka use pivot bnane aur uske sathnl formula main kar sakte hai
Haan ..kar skte h
Superb video sir
I am also learned VBA code
Good 👍♥️
Please make more video sir
👍❤️
sir VBA ki video upload kr dijiye
👌🏻👌🏻👌🏻👌🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
Sir
Mein Mastering excel video course liya hain (21 July) ,agar mujhe koi query hoti hai to kaise resolve kar sakta (aap tak kaise share kar sakta hun)
@innozantofficial telegram id hai use sir direct handle karte hain saath hi monthly Doubt session attend kar sakte hain aap,For more information contact Team Innozant
@@Innozant thank you 😊
1st view sir ❤️❤️💯🔥
Thanks Altaf..Keep learning..aap students ke comment par respond karte hai ye apke positive aur knowledge spreading attitude ko show karta hai..Good job ..keep exploring
Koi Faida Nhi Macro Record karka Macro enable ma Save karka Excel Band Kiya uska Baad Next day New Raw Data Mela Ab wo Macro nhi Ho raha ha
Sri practice file kaha milegi
❤️❤️❤️❤️
Sir,
How we make macro there is blank row or column in data..
Soon you may able to see
Sir mis excutive job ke liye kya interview english mein hota hai
Ha
Yes and no both are...and it depends and vary frok organization to organisation
But apko comm skills par utna hi mehnat karna hai jitna technical skills par
No words just amg
Thanks Suraj ji
application.onkey method ke bare main bataiye sir..
Personal macro ka shortcut key kaise banaye vba se please bataiye
Saare questions ke answers mil rhe honge ..in sequence course upload hoga dear..have patience
@@Innozant Sure sir,
I am waiting
Sir data validation ki list mai blank cell ko hatane ka tarika bataye
Question sahi se type kariye
Data validation me upper right corner per dekhiye....koi check box hoga blank cell ke liye
Pawan ko answer kariye Jin logon ne topic padh liya hai wo log..👍♥️
Sir please upload the next video 🙏
👍❤️
🙏🙏
Do reply sir pls …. mai bahut bure data me fasa hu regarding to Importrange
Kya issue aa raha hai.
Kindly share on @innozantofficial telegram id
🙏
Thanks
Send me full series of vba automation video
It is in process..please follow VBA automation playlist for the same
Sir Macro me pivot table nahi lag rahi
Kya issue btaiye
1004 error a gaya.. Kyu ki mere text number format me the..
Sir, Macro को और अधिक describe करे, ऑफिस use में कैसे ले इसे l मेरे साथ बहुत परेसानी आती है ऑफिस में work करते समय, report बनाते समय, बहुत समय lag, जाता है, दिनभर का processing data को consolidate करके, pivot table लगाकर रोज report बनानी पड़ती है, कृपया मार्गदर्शन करे l Macro Record करने में please apki help चाहिए l दूसरा problem है कि, morning मे सबको Allocation होती है सभी processors को data, सबका नाम रहता उसमे, और बहुत सी columns भी होती है, उसमे से सिर्फ अपने नाम का data filter लगाकर copy paste करना पड़ता अलग sheet पर, फिर vendor wise कुल कितने bills मिले हैं process करने के लिए उसके लिए countif formula लगाना पड़ता है, फिर एक दो comulns भी जोड़ना पड़ता है, उसमे voucher number लिखने के लिए, इतना सारा काम रोज रोज same way मे करना पड़ता है, गधा जैसे, कृपया मार्गदर्शन करे l I want to become expert, An Pro Excel Operator, so need to be your attention please help me sir please 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Please sir
Again only one word is there for your video that is,
Supercalifragilisticexpialidocious😁
Ek hi dikkat h bs video ane me 1 month lag rha h 😑
Hahahaha.. Thanks..aayega dear
macro recording samjha nahi aati hai sir..
Bahot easy hai thora sa brain chalana hai......😊
@@Altaf_Alam sheet ko Krna sheet ke ander nahi
@@mayurrajude VBA code bahut hi easy hai
Yadi aap JavaScript shikhe hai to VBA code sikhana bahut hi easy hai
Aur JavaScript nahi shikhe hai phir kar sakte hai but starting me aapko thoda problem ho sakta hai
Esme only aapko property method aur eske syntax ko yad rakhna hai
@@mayurrajude kya matlab ?🤔
Good Altaf
Videos aaane me bhut time lag rha h...
Yes duebto lack of time
ye log bus aise hi bolte hai jab aap subscriptions le loge to ghanta nahi samjh me ayega
Number do apna
Chandan ji lagta hai first time channel visit kiya hai apne Innozant,Pehli baat maine aaj tak Subscription ke liye kbhi channel par nhi bola hai ,dusri baat Complete course in sequence step by step premium content FREE me padhya hai jo koi nhi padhata,Ek baar dhnage videos playlis dekhne,Na apko subscription lene ki jarurat hai na ek rupye apne kharch karne ki aur aap seekh nhi ache se knowledge gain krenge wo bhi bina ek Paisa lgaye is baat ki bhi guarantee.
Keep Learning..Keep Exploring.
Apko statment jayaj hai ..Thagaye hue insaan lag rahe hain aap..😊♥️
Sir.. aachha shikhate hai.. usme koi 2 baat nahi.. Inka paid version lena Purta tension na lo..
Aspki baat sun kr bhut dukh huaa innozent pr bhut hi shandar videos h .....sir ne bhut hard work kiya Jo videos me dikhta h...
Hello dear, God bless your efforts.
I am a totally newbie vba learner.
I come to play with that code and have a simple enquiry.
How could i amend this code so that i can return all generated workbooks, inside a folder by which the code is run.
Thanks a lot
Sub test()
Dim rg As Range, i As Long, wb As Workbook
Dim vNames As Variant, v As Variant
Set rg = Workbooks("All raw data.csv").Worksheets("All raw data").UsedRange
'get unique names
With CreateObject("Scripting.Dictionary")
For i = 2 To rg.Rows.Count
.Item(rg.Cells(i, 1).Value) = Empty
Next i
vNames = .keys
End With
For Each v In vNames
ThisWorkbook.Worksheets("Sheet1").Copy
Set wb = ActiveWorkbook
wb.SaveAs v, 51
rg.AutoFilter 1, v
rg.Offset(1).Columns("A").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 1)
rg.Offset(1).Columns("U").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 2)
rg.Offset(1).Columns("Q").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 3)
wb.Save
Next v
End Sub
You just need to run this script and you will get the desired result ,If you are asking me to explain the code then unable to explain here as you need to raise a query on @innozantofficial telegram id
Thank you ❤
Thank you so much sir 🙏
Thanks dear