After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos..
After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos.. Excellent, I really appreciate your effort, Thanks A Ton Again :-) This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL . Very Unique way of teaching, Keep it up.
Excellent, I really appreciate your effort, Thanks A Ton Again :-) This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL . Very Unique way of teaching, Keep it up.
Very well explained Bro.. 👌 I'm not developer but what you want to tell at the end I totally understand... Thanks & keep going... Follow yoy from so long maybe this is my first comment.. I'm also computer faculty taught all this but thanks again... 🙏👌
I have seen your few videos in VB and must say that your teaching style is simple but comprehensively covers the contents. I am new to VB and want to learn the language step by step but have observed your videos do not appear in a sequential order. Is there a way I can access them according to the subject. Thanks
sir, can you please make deep lecture in VBA and SQL. I mean details of both to gain all knowledge relevant and your lecture very help full to us so easy to understand to VBA and SQL please sir, I hope you can doing well
Record Macro =========== 1)Open Balnk Sheet 2)Developer Tab ==> Record Macro ==> Use Relative Refferances ==> Record Macro 3)Record Macro Dialogue Box will Open ==> 4)Give Macro Name ==> Example)myColor 5)Give Keyboard Shortcuts ==> Shortcut key ==> Ctrl+Shif+A 5)Chhose Store Macro in ==> This Workbook 6) Description ==> Example) You make Color when run this Macro using Shortcut or Windows Screen 7)Recording has been Opened. 8)Now make Color in First Colum (A1) and then place the Cursor C1 9)Stop your Recording 10)Now Using Shortcut you can run Macro
Dear sir, I went through your video on creating macro and I found it very well explained. I have a small difficulty as I am a beginner for macros. I want to create a macro to copy a part of text from one cell and append it to the text in another cell. How to go about this? Pl help.
Hi Pavan NIce Tutorial on Macros Recording..I want to create a macro which takes input from Sheet2 and adds some cells and the resulted value is displayed on Sheet1.
Hi Mr,Pavan. Thank you so much for all the useful videos. I have tried to create a excel Macro as mentioned in this video. The coding was created like this.(Please look into "Range" at the end). Once I select Ctrl+Shift+A, at any cell, it Automatically lands on C1 cell. How to resolve this without editing manually, like given in your video. Thanks in Advance Sub Color() ' ' Color Macro ' This will color the Cells ' ' Keyboard Shortcut: Ctrl+Shift+A ' With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 65535 .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("C1").Select End Sub
Sir ek hi cell me likha he jese Tax Invoice- 4350 Hsn- 9001 Qty- 500 @ 25/- Hsn- 7015 Qty- 454 @ 670/- Ese karke bahut sare cell me likha jisme invoice no. Sabke alag hen hsn no. Alag alag hen bahut tarah ke hsn hen me chahta hu ke pura cell color full n ho jese mere hsn 9001 ke only text ka color hi change ho pure cell ka ni 9001 jaha jaha likha ho uska text green ho jaye 7015 ka red ho jaye 9015 ka blue ho jaye kya esa ho sakta he if yes to plz mujhe batayen
Hi. After I colored A1 cell, I choosed C1 cell. But my macro didnt work like this video. When I run my code, was colored A1 cell but was choosen always C1 cell; not after 2 columns. How can I do🥲
HI i am learning VBA ,by watching your videos for my project,I am facing a problem in VBA coding,when i run macro,other live feed data in different column getting freeze not updating data and i cant able to access other sheets/tabs of the Workbook as long as macro running in background.when i press ESC tab,only i can access. my project is copy and paste data between selected range for every 15 min. ---------code follows---------- Sub Copy_PasteSpecial() Application.Wait Now + TimeValue("00:00:05") Sheets("LATEST").Range("E2:F150").Copy Sheets("P_OI").Range("B3:C153").PasteSpecial Paste:=xlPasteValues Application.Wait Now + TimeValue("00:15:00") Sheets("LATEST").Range("E2:F150").Copy Sheets("P_OI").Range("D3:E153").PasteSpecial Paste:=xlPasteValues Worksheets("P_OI").Columns("B:G").AutoFit Application.CutCopyMode = False End Sub ----------------------- Mentioned 15 minutes of wait time,i cant able to update live data feed a column which is in same sheet and cant able to access other sheets/tabs. please guide me on my issue. tq
When a data is entered in one Excel sheet on a particular date, it should automatically be entered in another Excel sheet. Is there any formula for that?
@@sathishs9962 TH-cam comment section is not an ideal forum to understanding Query, share Solution. Hence, please contact Me on goodnessshallprevail@gmail.com with Query and all relevant details before We explore Solution. Thank You!
This kind of macro is working for same sheet. But If you want to do it with another sheet, it's not working. Is there any way to record micro permanently.
Sir i have 100 items with different size , I am very confuse to control these items, I wish i create the different sheets with different size then create the use form with combo button and just enter the data and vba transfer this data in his distination, Pls help to me for this matter ? Pls sir
Get Certified in Excel VBA:bit.ly/41fWeVP
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
Sir if we want to learn macro in another sheet how is that possible for us to record
You are the best excel tutor I found in last 5 years...
You are an asset Sir. The way you taught is just fabulous.
After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos..
After seeing your videos I could easily understand VBA. Thanks for that . I informed all my friends to view your videos to learn it better.. they also subscribed and watching your videos..
Excellent, I really appreciate your effort, Thanks A Ton Again :-)
This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video
Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL .
Very Unique way of teaching, Keep it up.
What ever the topic you choose you are giving 💯% expected answers
Love you and your videos bro thank you!!!
Excellent, I really appreciate your effort, Thanks A Ton Again :-)
This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video
Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL .
Very Unique way of teaching, Keep it up.
Congratulations Sir 🎉
Your video used in excel virtual internship through JP Morgan Chase & Co. 😅
Nice explanation, the people who dnt know the basic about macro can understand by watching this video,it helped me alot thk u
your's delivery of the content is simply superb and clear
I freaking love you man, keep it up!!!!
just an appreciation comment....you really saved me tysm...idk how to express it but tysm.
All your explanations were very clear and easy to understand. You are a great teacher
You are very articulate in teaching
Hatsoff to you
Master in teaching skill .. amazing ❤🎉🎉
OMG.! Wonderful Mr.
Your way to teach ..is amezing..I learn macro so quick from your video... Thank-you so much!
Your video regarding Excel & VBA are very helpful for learners
Thank you soo much
Great job
I have found another excellent teacher after kuduvenkat
Your explanation is amazing, what a claryity... I became your fan👌
Thank you so much for explaining it in a very clear way I could learn the first simple macro now Thanks a lot again
Very well explained Bro.. 👌 I'm not developer but what you want to tell at the end I totally understand... Thanks & keep going... Follow yoy from so long maybe this is my first comment.. I'm also computer faculty taught all this but thanks again... 🙏👌
Coming in clutch rn I have to make a macro and function sheet for my final and these videos are helping a lot!
It feels live with this kind of presentation.
I really appreciate the work u do bhai... Bas just a request if u could make a whole vdo of the set i. e.. VBA.. that would b of great help bhai...
Thanks alot ....I informed & share your tutorials link to my all students to learn it better...
very well explained from basics, Thank you
I have seen your few videos in VB and must say that your teaching style is simple but comprehensively covers the contents. I am new to VB and want to learn the language step by step but have observed your videos do not appear in a sequential order. Is there a way I can access them according to the subject. Thanks
I am really impressed the way you are explaining.
very very helpful sir, hats of you for free education for our student
I love the way u explained... Really thanks 🙂
very good teaching method sir!! simple and to the point !!!!!!!
Nice super class sir.simple understand. Voice and explain action.super
sir, can you please make deep lecture in VBA and SQL. I mean details of both to gain all knowledge relevant and your lecture very help full to us so easy to understand to VBA and SQL please sir, I hope you can doing well
Very nice sir
Thanks for making me understand the macro.. in an easiest way. Thanks a lot teach like speaking curser on the computer screen 😉
Record Macro
===========
1)Open Balnk Sheet
2)Developer Tab ==> Record Macro ==> Use Relative Refferances ==> Record
Macro
3)Record Macro Dialogue Box will Open ==>
4)Give Macro Name ==> Example)myColor
5)Give Keyboard Shortcuts ==> Shortcut key ==> Ctrl+Shif+A
5)Chhose Store Macro in ==> This Workbook
6) Description ==> Example) You make Color when run this Macro using Shortcut or
Windows Screen
7)Recording has been Opened.
8)Now make Color in First Colum (A1) and then place the Cursor C1
9)Stop your Recording
10)Now Using Shortcut you can run Macro
Very nice ,clear and easy lesson about macros
Sir
Good job and excellent teaching
Directed From JP Morgan Chase co Excel
U r awesome sir.
Plzzz make a video on PowerPoint macro feature
Thank you soooooo much sir, you're amazing please continue to do so.
excellent give knowledge .... have you learn of macro coding? Pl confirm
thanks a lot sir for teaching and cooperation
Nice way of explaining
nice presentation sir
Clear explaination..👍👍👌
Great sr thanks very much !😁😁😁
Nice teaching easy to understand
Great presentation.
Whether pivot table can be recorded in Marco??
Really very nice..keep it up bro
Dear sir,
I went through your video on creating macro and I found it very well explained. I have a small difficulty as I am a beginner for macros. I want to create a macro to copy a part of text from one cell and append it to the text in another cell. How to go about this?
Pl help.
Superb presentation
Excellent teaching
Is it possible to create a CSV file through macro for a particular row or column?
Your my favourite ☺️
May I know which display device Sir is using?
Is it applicable for excel formulas like vlookup
Hi Pavan NIce Tutorial on Macros Recording..I want to create a macro which takes input from Sheet2 and adds some cells and the resulted value is displayed on Sheet1.
Thank you Sir..Please also help ,how to write macros with if function to identify text in cell.
I did exactly same but a error dialog box came after I gave the command Ctrl+Shift+A, why ?
Brother your Tutorials helps me lot
🙏
Is it possible to create a multiple CSV files through macro ...?
How screen at back is operated by touching the screen
Prior to explaining what macro is and how it works. You should tell everyone that where from you get the developer tab.
Hi Mr,Pavan. Thank you so much for all the useful videos. I have tried to create a excel Macro as mentioned in this video. The coding was created like this.(Please look into "Range" at the end). Once I select Ctrl+Shift+A, at any cell, it Automatically lands on C1 cell. How to resolve this without editing manually, like given in your video. Thanks in Advance
Sub Color()
'
' Color Macro
' This will color the Cells
'
' Keyboard Shortcut: Ctrl+Shift+A
'
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("C1").Select
End Sub
Crisp and clear
Sir ek hi cell me likha he jese Tax Invoice- 4350 Hsn- 9001 Qty- 500 @ 25/- Hsn- 7015 Qty- 454 @ 670/-
Ese karke bahut sare cell me likha jisme invoice no. Sabke alag hen hsn no. Alag alag hen bahut tarah ke hsn hen me chahta hu ke pura cell color full n ho jese mere hsn 9001 ke only text ka color hi change ho pure cell ka ni 9001 jaha jaha likha ho uska text green ho jaye 7015 ka red ho jaye 9015 ka blue ho jaye kya esa ho sakta he if yes to plz mujhe batayen
Super Sir
Hi. After I colored A1 cell, I choosed C1 cell. But my macro didnt work like this video. When I run my code, was colored A1 cell but was choosen always C1 cell; not after 2 columns. How can I do🥲
Very clear.....good
Is it possible to do multiplication and division in same macro.
Great explanation
Very clear,, thank you so much
Sir witch screen use
HI i am learning VBA ,by watching your videos for my project,I am facing a problem in VBA coding,when i run macro,other live feed data in different column getting freeze not updating data and i cant able to access other sheets/tabs of the Workbook as long as macro running in background.when i press ESC tab,only i can access.
my project is copy and paste data between selected range for every 15 min.
---------code follows----------
Sub Copy_PasteSpecial()
Application.Wait Now + TimeValue("00:00:05")
Sheets("LATEST").Range("E2:F150").Copy
Sheets("P_OI").Range("B3:C153").PasteSpecial Paste:=xlPasteValues
Application.Wait Now + TimeValue("00:15:00")
Sheets("LATEST").Range("E2:F150").Copy
Sheets("P_OI").Range("D3:E153").PasteSpecial Paste:=xlPasteValues
Worksheets("P_OI").Columns("B:G").AutoFit
Application.CutCopyMode = False
End Sub
-----------------------
Mentioned 15 minutes of wait time,i cant able to update live data feed a column which is in same sheet and cant able to access other sheets/tabs.
please guide me on my issue.
tq
can you help me to to find out %increase or %decrease of live data which is updated every minute....?
thank you sir😘😘😘😘😘😘
Very simple and awea
Hi Sir, How can I learn Macro from you.. Is there any online class going on.. Kindly let me know
Thanks, very well explained.
th-cam.com/video/4bT2TtjK1GM/w-d-xo.html
When a data is entered in one Excel sheet on a particular date, it should automatically be entered in another Excel sheet. Is there any formula for that?
Hi Sathish,
Yes, this can be done.
Please contact Me on goodnessshallprevail@gmail.com.
Thank You!
Hi. This is Mr Sathish. You have told that my query is possible. Could you kindly guide me?
@@sathishs9962
TH-cam comment section is not an ideal forum to understanding Query, share Solution.
Hence, please contact Me on goodnessshallprevail@gmail.com with Query and all relevant details before We explore Solution.
Thank You!
Thank you so much
This kind of macro is working for same sheet. But If you want to do it with another sheet, it's not working. Is there any way to record micro permanently.
Same question here
you click on "all work sheets"
Very good
this trick of adding color is working but when i undo it undo is not working color of cells still remains same
How to use this macro in another excel sheet
Thank you Sir
Thanks so much...
I'm having very low sound issue. Can the volume be increased please?
Very nice ..but while doing practically,for shortcut shift not working
Sir i have 100 items with different size ,
I am very confuse to control these items,
I wish i create the different sheets with different size then create the use form with combo button and just enter the data and vba transfer this data in his distination,
Pls help to me for this matter ?
Pls sir
Can we open another application anyhow from ms excel and import data automatically other than live data transfer ?
Macro option is not getting enable, please help to enable the same.
Very helpful
thank you
Are you Cris cross from movie kai Po Che
thanks a lot sir.
sir what to do? excel show a massage unable to record macro.
Wonder full program
Hay can u please help me to learn macro,
I am searching some books related to it plss suggest me