I have watched a lot of videos on excel formulas and vba macros, and you are by far the best at explaining these concepts and methods in a way that sticks. When I'm writing formulas or macros, I hear you in my head -- like when I'm writing an Index Match formula. Thank you for all of your wonderful videos! ♡
I just ran across this video while searching for something else. It so happened that I needed to do this very thing in my current project. I don't believe I would have been imaginative enough to record absolute and relative in one procedure. Not only does it get the job done, it is simple and uncluttered. This was a big help. Thanks again L!
No doubt its a Great work, Till today I use the below technique to perform this job Range("A8").Select Selection.End(xlDown).Select a = ActiveCell.Column b = ActiveCell.Row Cells(b + 1, a).Select
Hi Leila, thank you for so much you are the best teacher we can ever have... I love this channel a lot... i learned many things from you channel and download the sheets and working on it every day.. God bless you abundence
Thank you Madam, long pending work just materialized, Your way of explaining the things is very beautiful, simple and memorable. Thanks a lot. Waiting very eagerly to learn some more tricks/tips/techniques. You are very lucky, many many followers are appreciating your great work and the love for Excel is growing everyday. BIG SALUTE
Thank you very much Gopala - Yes - finally macros and VBA :) I'm glad the love for Excel is growing every day. I appreciate your support and the support of all other followers.
you have a well way to teach excel and now vba too,with simple example and step by step, I learn from you for doing better in writing formula and now i'm trying to learn vba.with youre first lecture about know how and when turn on/off relative reference in recording macro.this is the good start to learn it, I see what happend when i do somthing.very very thank you.
I'm really happy to hear that Mohammad! Thank you for the very nice comment. Yes Macros are really powerful and actually quite easy to use. This week we'll see some more on macros. Thank you for the support.
Awesome Explanation. Many months before i started learning VBA Excel but couldn't successful because explanation of that man was not looked professional and he use just Inputbox and msgbox to show results of coding. Now you are teaching EXCEL VBA and i hope, i will learn perfectly and professionally. as i learned before INDEX, match, offset and their techniques to use. Thank You so much for great Explanations.
Thank you Fahad! I'm very glad to hear you find the explanations easy to follow. It took me a while to add VBA to my courses, because like you say, it's a difficult topic to teach. It took a lot of thinking in creating and defining the outline and flow of the course. I'll share what I can on UA-cam as well. Just now I posted a video regarding range references. If you're interested, check it out. Wish you all the best with your learning.
Thank You so much for suggesting. Last night i saw all your 3 videos on VBA and also practiced. You cover many important things as for beginners. I didn't learn many month ago enough that you cover in one video. Keep it up. Great Work. Very Happy To Learn By You.
i'm learning excel from you. You are my Master to develop me. I learn so may ideas from you (its 40-50%), its better for me. How can I told you, their is no words to say ! I cannot speak and write good english, but from your tutorial i can something to write and speak english, i'm leaving in tribal area. So mam thanks a lot. Mam now a days from your tutorial i'm interested in basic VBA.
Thank you so much for your very nice message Shirish! I'm very happy to hear you find the tutorials useful. Thank you for watching and for your support.
Hey Leila. Thanks for sharing this awesome knowledge. Not only does it help me in my work but it seems i look forward to learning with you and every day I learn something new. You are also very pretty. Keep it up
Seriously You are Amazing in explaining in detail. Thank you for doing such a noble Job.I have seen many excel tutorial but your explanation worth watching and entertaining.
Very useful tutorial. It will be further useful if could put another tutorial for how to copy data from summary sheet to different sheets based on some criteria using VBA
Awesome! Although you missed to teach or show how to remove the range referencing to A1 for relative macro recording. And you are right, it still works.
Hi, thanks for all the great excel training videos. I recorded a macro to execute formatting I apply to a report I recieve multiple times a day. One of the formatting I apply is insert table, but the macro fails to input the table because the # of rows for each report vary - sometimes it's more or less. How can I write the macro so the code updates to the relative # of rows? Thanks.
start learning power query , I use to download several spreadsheets about 35 each month and copy it to the spreadsheets by customer. it took me a lot of work to automate The process!! With macros and ChatGPT ! I have a macro that ask me what file to open and where to copy them and then ask me if I want to save the file and if I want to open a new one. Before power query I had a formula to take care of the variable of the size of the different sheets. Started on a new payroll proyects using power query and macros and its a lot more faster. Dont worry no more on the size of the worksheet, with the tables of power quey Thank You Leila !
You explain topics nicely and fluently. I want to know that is there any plan of Microsoft corporation that excel will handle big data? By big data, I mean data records in millions.
Currently, taking your Excel VBA course. So far i am thoroughly enjoying the course. I am also interested in web scraping with VBA. Can you make any tutorial or course on that.
Hi Anil. Thank you! I'm glad to hear you like the course. I'm not really experienced in web scraping. If I get a chance I'll look into it and see if I can come up with some tutorials....
Amazing Leila. I am not much into Macro recording. I am more of a formula person thanks to Mike :) but this was very interesting and I will surely follow your coming videos to learn new staff, maybe I will learn some VBA from you. Thanks
You're very welcome John! I understand - I love formulas too. Macros are really great though for automating routine tasks. I'm curious what you think about the next videos...
i have seen many videos of your its which have help me save lot of time , now if we have lots of data and transfering that data partywise to another sheet but if that data is more then 1 page i want to show that data head to all the other pages also
Hi Leila, 1st of all Tank you so much for sharing these priceless knowledges. can you make a session on Splitting data from on Master sheet to another multiple sheet as per sales country or department wise by VBA coding.
Thanks a lot ❤️❤️❤️ .. I was struggling with one error & didn't know how to find solution inspite of doing everything right. Seeing this video I realised my mistake.
Thank you so much, I have question please, my data contains a lot of zipcodes. I want do analyze them in different aspects such as population, income and so on and the step like following 1- find the nearest zip values and compare them to the primary zipcode and then rank the primary code. 2- keep the primary zipcode along with nearest zipcode. So when I search for primary zipcode the nearest code should appear too. Can you please advise me what type of formula I use? And on how to group primary zipcode with nearest zipcode? Thank you again for your very useful videos
Hi Leila, your videos are super helpful. I have been able to accomplish this same task on my own but I am struggling to figure out how to make it work within a table with an empty data set. Any suggestions? Thank you!
Hi Leila, this is really helpful! thank you! I do have a problem with blank data not copying across using this method. Is there alternative solution I can use? thanks
Thank you very much for your help! It was so easy once I saw your video! I was looking for a solution for 2 days and I found just what I needed with this video!
Thank you for your nice lessons. I have one problem applying the steps, pressing Enter key pastes the copied cell's content. Is there anyway I can avoid that?
I like the way you teach us with a pure calmness on your face showing how easy it was. However, I need a complex job for this macro to perform. I have libreoffice in linux and I copy some data from one sheet and paste into another one opened separately which called "invoice" and it has a list of hundreds of invoices. when i put data from the summary sheet to the invoice sheet, I give it a sequenced numeric name and press F12 to "save as" and start editing the next sheet by copying some data from the summary sheet and paste it in the invoice sheet and press F12 to ''save as'' and give a name by increasing the last digit of the invoice' name . I want it to automate for me. how can I do that?
Hi Leila, first of all - thank you for your great content! I hope you are able to help me with my question as I was not able to find an answer yet... Let's say I have created a table and a form and a button that will enter a new row to it with a data I have entered in the form. The only option I could find on line was to add it as a last row. Is it possible to enter it somewhere at the middle? Let's say I want to select (in the form) the location of the new row in the table. Is that possible? And one last question - If my table is placed above a different table or some row that is not related to it - is it possible to push the row doen to add additional rows to the table through forms? Hope my questions are clear and thanks again fir the great content!
What VBA is: VBA (Visual Basic for Applications) is programming language for all office applications. It is still something that should be learned and can easily differentiate you from other Excel users. You can automate the recurring tasks, which you do regularly and repeatedly, through basic VBA programming. Each of the office products has its backstage for programming. You can make EVENTS for any of the Commands that you see on the front-end Ribbon menu. EVENTS are the series of commands written in VBA project. Automation through VBA: The owner of 20 hotels has revenue data for the year to date 2020. He needs to view monthly data by hotels at a glance and needs to create a Chart for this. If his Excel operator knows to work only at the user interface, the front-end of Excel, then it will take two hours or more for him to consolidate data from several sheets and take to a pivot source and then make a pivot table and a pivot chart. Whereas this can be automated in VBA and can be used later just on click. Here is an example of this automation which you may like to watch. facebook.com/VBA-Expert-Momtaz-103391721501133/
You just save me time and struggle, clear as water. It's always great to learn new things, like I just have a revelation, THANKS!!!!. Is the course one time payment lifetime access? just making sure I understood right.
Very nice video Leila, I have really enjoyed watching it. My question is, I do have good knowledge of power query but starter knowledge in vba, so will studying vba add advantage to my knowledge?
It depends on what you want to do Ali. If you want to create tools to automate tasks or to build tools to increase efficiency it will definitely add value.
Hi, Leila. What if the sheet where the data will be copied to is still empty. For example, only the headers are available in sheet 2 because it waits until there is a data in sheet 1. Is this possible?
Hi Leila , Thank you for your great and awesome materials. i just wonder if you can help me out with getting access to Menu bar in Excel via VBA? i would like to check whether one particular Tab ( the custom tab i made) is there or not.
Thank you for your vidoes. i have a question, if i wann copy certain columns (not all columns) from one sheet to another sheet, how can we record the Macro. Thansk
Thank you Leila for the video. You have demonstrated the concepts in a easy to understand way. I was looking for something similar. Do you have any videos made where you can copy & paste columns from one workbook worksheet to another workbook worksheet using VBA? Example: Workbook 1 - Source.xls worksheet - Data 1 Workbook 2 - Destination.xls Worksheet - Main Copy data from worksheet 'Data 1' column A to worksheet 'Main' column C The VBA code would be in workbook 2. The copy paste is done without opening workbook 1 Thanks again and appreciate your help
Hi Leila, I am not sure if you have this if some of your previous videos, maybe you could point me to it? I am fetching data from Web in one tab getting live cryptocurrencies prices. Now I have another tab where I am having my portfolio for every cryptocurrency I own. How can I link price from first tab to this one to automatically updated for desired crypto? My problem is that in first tab cryptocurrencies changing their order every time when updated. Thanks a lot in advance!
So I have just had this job and I produce Same report every week. I am curious to know how I can fit in macros from copy pasting from the accounting software xero into excel. If there is any course you have I am happy to sign up as this will help save loads of time. I have tried recording macros however, it does not work, when I come to produce the reports.
Hi Leila, thanks for this video. This really helped me a lot to understand how Macro works. I just have one question, what if we add new rows from NewData#1 and 2 will the macro will capture the new rows in SummaryData sheet? I’m trying to create a running file from different sheets and integrate it in one sheet
Is there anyway to add Macro for the sheets will be added in future? For example monthly sheets done until August but will be added until December later o
Grab the file I used in the video from here 👉 pages.xelplus.com/vba-copy-data-file
This link doesn't work after I enter my details. Could you please check?
You might not know but you are great at what you do. May your future be the Brightest. Thank you for bringing such incredible knowledge to us.
I have watched a lot of videos on excel formulas and vba macros, and you are by far the best at explaining these concepts and methods in a way that sticks. When I'm writing formulas or macros, I hear you in my head -- like when I'm writing an Index Match formula. Thank you for all of your wonderful videos! ♡
Many thanks for the kind feedback. I'm glad you like the videos :)
I just ran across this video while searching for something else. It so happened that I needed to do this very thing in my current project. I don't believe I would have been imaginative enough to record absolute and relative in one procedure. Not only does it get the job done, it is simple and uncluttered. This was a big help. Thanks again L!
Omg!! your voice is just harmony to my ears thanks for all these pro videos
Wow, thank you!
You are the only lady teacher I am listening to right now. Easy to follow
That's good to hear :)
No doubt its a Great work,
Till today I use the below technique to perform this job
Range("A8").Select
Selection.End(xlDown).Select
a = ActiveCell.Column
b = ActiveCell.Row
Cells(b + 1, a).Select
I like her way of talking. I wish I could be like her. She explains in a way that I really like. Thanks Ma'am.
You just gave me a solution of a problem I'm trining to solve from three entire days of research on forums and UA-cam videos. Many thanks 🙏
This is a great explanation. This is what I needed. You explain the differences and logic of how they work.
Hello Ms. Leila, you are one of the best teacher I have seen. Thanks lot for tutorials.
Thanks Leila. I like the way you explained techniques. It's easy to understand, and your method is cool.
Glad you like it :)
Hi Leila, thank you for so much you are the best teacher we can ever have... I love this channel a lot... i learned many things from you channel and download the sheets and working on it every day.. God bless you abundence
You rock Ms Excel. You save me a lot of time an effort and not to mention. just sent my work in. You're a Godsend
Really loved your narration n crisp clear explanation with calm tone.Great job!👍 Thanks for the new chapter
You're very welcome. Thank you for your comment. I'm glad you like the pace of the tutorial.
Anytime i need a solution to any Excel Problem this is the place i find the perfect solution i need.. Thanks a ton :) :)
Outstanding Ms Gharani. I've learned so much from you over this past 18 months
I'm very happy to hear that. Thank you for your support over the past 18 months :)
Thank you Madam, long pending work just materialized, Your way of explaining the things is very beautiful, simple and memorable. Thanks a lot. Waiting very eagerly to learn some more tricks/tips/techniques. You are very lucky, many many followers are appreciating your great work and the love for Excel is growing everyday. BIG SALUTE
Thank you very much Gopala - Yes - finally macros and VBA :) I'm glad the love for Excel is growing every day. I appreciate your support and the support of all other followers.
Thank you very much Madam
you have a well way to teach excel and now vba too,with simple example and step by step, I learn from you for doing better in writing formula and now i'm trying to learn vba.with youre first lecture about know how and when turn on/off relative reference in recording macro.this is the good start to learn it, I see what happend when i do somthing.very very thank you.
I'm really happy to hear that Mohammad! Thank you for the very nice comment. Yes Macros are really powerful and actually quite easy to use. This week we'll see some more on macros. Thank you for the support.
The Most valuable Video for a Beginner who wants to learn how to run Macro in Excel. Thanks for the this awesome lecture.
Glad you liked it
Awesome Explanation. Many months before i started learning VBA Excel but couldn't successful because explanation of that man was not looked professional and he use just Inputbox and msgbox to show results of coding.
Now you are teaching EXCEL VBA and i hope, i will learn perfectly and professionally. as i learned before INDEX, match, offset and their techniques to use.
Thank You so much for great Explanations.
Thank you Fahad! I'm very glad to hear you find the explanations easy to follow. It took me a while to add VBA to my courses, because like you say, it's a difficult topic to teach. It took a lot of thinking in creating and defining the outline and flow of the course. I'll share what I can on UA-cam as well. Just now I posted a video regarding range references. If you're interested, check it out. Wish you all the best with your learning.
Thank You so much for suggesting. Last night i saw all your 3 videos on VBA and also practiced. You cover many important things as for beginners. I didn't learn many month ago enough that you cover in one video. Keep it up. Great Work. Very Happy To Learn By You.
i'm learning excel from you. You are my Master to develop me. I learn so may ideas from you (its 40-50%), its better for me. How can I told you, their is no words to say ! I cannot speak and write good english, but from your tutorial i can something to write and speak english, i'm leaving in tribal area. So mam thanks a lot. Mam now a days from your tutorial i'm interested in basic VBA.
Thank you so much for your very nice message Shirish! I'm very happy to hear you find the tutorials useful. Thank you for watching and for your support.
I have watched at least 6 videos trying to accomplish what you just taught. Thank you so much!
You're very welcome, Catherine!
You know everything to explain....in clarity...thanks again
Hi Leila, I have seen a few of your videos. They are really useful and I absolutely love how you teach! You do a great job.
Can you tell me why I press on like button before I watch video!!!
I’m still learning more from all videos, thank you so much.
Hey Leila. Thanks for sharing this awesome knowledge. Not only does it help me in my work but it seems i look forward to learning with you and every day I learn something new. You are also very pretty. Keep it up
I'm glad to hear that :)
This is what I was looking for. Tried on many blogs but finally found it here.....Thank you!!!! Perfect Video.... :))
You are most welcome.
Haven't seen any best teacher than you, looking froward to watch all the vids on ur channel
thank you so much ms. Leila I think it's my chance to learn macros really appreciate your video
You're very welcome Ismail. Macros are a lot of fun. It gets more fun when we get to tweak the macros and adjust them to our needs...
As always, this time also you explained the subject in a simple and beautiful manner. It is very helpful for us.
Thank you
I'm very happy to hear that. Thank you Fareed.
Great as always ! Thanks Leila, you are my bible !
Seriously You are Amazing in explaining in detail. Thank you for doing such a noble Job.I have seen many excel tutorial but your explanation worth watching and entertaining.
Thank you very much for the kind words! I'm glad the tutorial is useful.
Thanks Madam
i have watched your tutorial & I get imy Knowledge, God Bless you forever.
Very useful tutorial. It will be further useful if could put another tutorial for how to copy data from summary sheet to different sheets based on some criteria using VBA
Awesome! Although you missed to teach or show how to remove the range referencing to A1 for relative macro recording. And you are right, it still works.
Thanks for showing that we can use both relative and absolute options in single recording.
You are very intelligent.
You saved me nothing beats the feeling of an assignment well done 😁😁
Thanks for the cool video about Relative and Absolute References in VBA !!!
You're very welcome teammate Mike :) I'll be switching to some VBA fun for a little bit....
@@LeilaGharani you guys are frineds?.. Excells Fun is like my old teacher and now Leila is my university teacher.. Respect for both of you.
Hi, thanks for all the great excel training videos.
I recorded a macro to execute formatting I apply to a report I recieve multiple times a day. One of the formatting I apply is insert table, but the macro fails to input the table because the # of rows for each report vary - sometimes it's more or less. How can I write the macro so the code updates to the relative # of rows? Thanks.
I've just used it. Really useful. Thanks again.
Great to hear!
Beautifully explained in a very simple and effective way. Thank you.
You are welcome!
THANK YOU! I was not aware there was such a thing as Relative Recording until now.
Thank you SO MUCH! Your explanation was GOLD. You made it so easy to understand and it helped me with my work!
Leila Gharani, you are amazing! Many thanks to your effort and comprehensive explanation!
Excellent Video.. Really made it simple to understand and work with macros.. keep up the good work.
man I have trying to do this for years
Thank You !!!!
start learning power query , I use to download several spreadsheets about 35 each month and copy it to the spreadsheets by customer.
it took me a lot of work to automate The process!!
With macros and ChatGPT !
I have a macro that ask me what file to open and where to copy them and then ask me if I want to save the file and if I want to open a new one.
Before power query I had a formula to take care of the variable of the size of the different sheets.
Started on a new payroll proyects using power query and macros and its a lot more faster.
Dont worry no more on the size of the worksheet, with the tables of power quey
Thank You Leila !
You explain topics nicely and fluently.
I want to know that is there any plan of Microsoft corporation that excel will handle big data?
By big data, I mean data records in millions.
Currently, taking your Excel VBA course. So far i am thoroughly enjoying the course. I am also interested in web scraping with VBA. Can you make any tutorial or course on that.
Hi Anil. Thank you! I'm glad to hear you like the course. I'm not really experienced in web scraping. If I get a chance I'll look into it and see if I can come up with some tutorials....
Damn, after one video i'm the best VBA user of my organization 😂
Can't imagine when i finish all your videos
Thanks so much Great Teacher Leila
Haha, that's awesome! 😄 Glad the video was helpful. Keep learning!
Thank you Leila. Super awesome stuffs 👍🏾
Hi Leila, I would like to thanks for this class. I really understood very easily.
I'm glad to hear that :)
Great video as always - but did i miss the section on how to create a JPEG or GIFF file from the barcode created?
U r the best .. thank you for your time and effort in these trainings
It's my pleasure
Amazing Leila. I am not much into Macro recording. I am more of a formula person thanks to Mike :) but this was very interesting and I will surely follow your coming videos to learn new staff, maybe I will learn some VBA from you. Thanks
You're very welcome John! I understand - I love formulas too. Macros are really great though for automating routine tasks. I'm curious what you think about the next videos...
i have seen many videos of your its which have help me save lot of time , now if we have lots of data and transfering that data partywise to another sheet but if that data is more then 1 page i want to show that data head to all the other pages also
Thank you Leila, great piece of work, thanks for sharing with us. It helped me immensely and I appreciate your efforts!
Hi Leila, 1st of all Tank you so much for sharing these priceless knowledges. can you make a session on Splitting data from on Master sheet to another multiple sheet as per sales country or department wise by VBA coding.
Thanks a lot ❤️❤️❤️ .. I was struggling with one error & didn't know how to find solution inspite of doing everything right. Seeing this video I realised my mistake.
Wow, this is amazing! I am so looking forward to your complete course on VBA. Looks like I will be busy studying for a while 😍
Glad you like it! You should for sure put some time aside. But the good news is you have life-time access so you can go slowly but surely :)
Thank you so much, I have question please, my data contains a lot of zipcodes. I want do analyze them in different aspects such as population, income and so on and the step like following
1- find the nearest zip values and compare them to the primary zipcode and then rank the primary code.
2- keep the primary zipcode along with nearest zipcode. So when I search for primary zipcode the nearest code should appear too.
Can you please advise me what type of formula I use? And on how to group primary zipcode with nearest zipcode?
Thank you again for your very useful videos
Hi Leila, your videos are super helpful. I have been able to accomplish this same task on my own but I am struggling to figure out how to make it work within a table with an empty data set. Any suggestions? Thank you!
Hi Leila, this is really helpful! thank you! I do have a problem with blank data not copying across using this method. Is there alternative solution I can use? thanks
Always clear and easy to follow. Really appreciate your videos. Thank you!
You're very welcome Rosa. Thank you for your comment and your support.
Thank you very much for your help! It was so easy once I saw your video! I was looking for a solution for 2 days and I found just what I needed with this video!
I'm glad it was helpful Luis!
I don't need it for now. I just love watching good stuff
Thank you for your nice lessons. I have one problem applying the steps, pressing Enter key pastes the copied cell's content. Is there anyway I can avoid that?
I like the way you teach us with a pure calmness on your face showing how easy it was. However, I need a complex job for this macro to perform. I have libreoffice in linux and I copy some data from one sheet and paste into another one opened separately which called "invoice" and it has a list of hundreds of invoices. when i put data from the summary sheet to the invoice sheet, I give it a sequenced numeric name and press F12 to "save as" and start editing the next sheet by copying some data from the summary sheet and paste it in the invoice sheet and press F12 to ''save as'' and give a name by increasing the last digit of the invoice' name . I want it to automate for me. how can I do that?
Hi Leila, first of all - thank you for your great content!
I hope you are able to help me with my question as I was not able to find an answer yet...
Let's say I have created a table and a form and a button that will enter a new row to it with a data I have entered in the form.
The only option I could find on line was to add it as a last row.
Is it possible to enter it somewhere at the middle? Let's say I want to select (in the form) the location of the new row in the table. Is that possible?
And one last question -
If my table is placed above a different table or some row that is not related to it - is it possible to push the row doen to add additional rows to the table through forms?
Hope my questions are clear and thanks again fir the great content!
excellent, with the advantage of absolute and relevant reference working together
Thank you Joe.
Extremely useful thank you!
Thank you.. You posted this video at the exactly the right time I needed this..
Perfect :) I'm glad this helped!
Excellents presentation and work. thank you !
Glad you liked it!
What VBA is:
VBA (Visual Basic for Applications) is programming language for all office applications. It is still something that should be learned and can easily differentiate you from other Excel users. You can automate the recurring tasks, which you do regularly and repeatedly, through basic VBA programming. Each of the office products has its backstage for programming. You can make EVENTS for any of the Commands that you see on the front-end Ribbon menu. EVENTS are the series of commands written in VBA project.
Automation through VBA:
The owner of 20 hotels has revenue data for the year to date 2020. He needs to view monthly data by hotels at a glance and needs to create a Chart for this. If his Excel operator knows to work only at the user interface, the front-end of Excel, then it will take two hours or more for him to consolidate data from several sheets and take to a pivot source and then make a pivot table and a pivot chart. Whereas this can be automated in VBA and can be used later just on click.
Here is an example of this automation which you may like to watch.
facebook.com/VBA-Expert-Momtaz-103391721501133/
You just save me time and struggle, clear as water. It's always great to learn new things, like I just have a revelation, THANKS!!!!. Is the course one time payment lifetime access? just making sure I understood right.
Hey Leila, awesome tutorial and you explained it very neatly and in simpler ways.
Thanks Leila for this awesome video... You just made it easy!
Glad you like it Marcel :)
Very nice video Leila, I have really enjoyed watching it. My question is, I do have good knowledge of power query but starter knowledge in vba, so will studying vba add advantage to my knowledge?
It depends on what you want to do Ali. If you want to create tools to automate tasks or to build tools to increase efficiency it will definitely add value.
Much informative! Useful. I’m looking forward to your Excel VBA course! many thanks
Great video! One more question help please how to make copy rows with filtered data ? Thank u.
Thanks for informative videos. Would you kindly let me know how do I Copy the same location values from every sheet into a table
Hi, Leila. What if the sheet where the data will be copied to is still empty. For example, only the headers are available in sheet 2 because it waits until there is a data in sheet 1. Is this possible?
Hi Leila , Thank you for your great and awesome materials. i just wonder if you can help me out with getting access to Menu bar in Excel via VBA? i would like to check whether one particular Tab ( the custom tab i made) is there or not.
Hey Leila, Thanks! Do you have a video to select selective columns from one worksheet to another in same excel? or this video should be enough?
Hi Leila could you please upload a video how to control a existing automation tool.. 🙏
Fantastic. Thanks for sharing. I knew this like some other training but i love your training .
Thanks.
Thank you. Appreciate your support.
I just subscribe to your channel since Ive learned new macro today!
That's great. Glad to have you here :)
Hi Leila. Can you advise all the Vedio here is same as the one in udemy? Was try to sign in to that.
Thank you so much.
I would be looking forward for more videos on macro & VBA coding.
You're very welcome. Yes :) more coming this week...
Thank you for your vidoes.
i have a question, if i wann copy certain columns (not all columns) from one sheet to another sheet, how can we record the Macro. Thansk
Thank you Leila for the video. You have demonstrated the concepts in a easy to understand way.
I was looking for something similar.
Do you have any videos made where you can copy & paste columns from one workbook worksheet to another workbook worksheet using VBA?
Example:
Workbook 1 - Source.xls
worksheet - Data 1
Workbook 2 - Destination.xls
Worksheet - Main
Copy data from worksheet 'Data 1' column A to worksheet 'Main' column C
The VBA code would be in workbook 2. The copy paste is done without opening workbook 1
Thanks again and appreciate your help
Thank You very much Ms Leila!
Ma'am it's really well explained & helpful. Thanks a lot
Hi Leila, I am not sure if you have this if some of your previous videos, maybe you could point me to it? I am fetching data from Web in one tab getting live cryptocurrencies prices. Now I have another tab where I am having my portfolio for every cryptocurrency I own. How can I link price from first tab to this one to automatically updated for desired crypto? My problem is that in first tab cryptocurrencies changing their order every time when updated. Thanks a lot in advance!
Your new course looks really interesting. Can't wait to buy it!
Thanks Andrew :) It's been a lot of work and but also fun putting the course together. I'm looking forward to your feedback once it's out.
This is so nice, Leila you are just the best. I love the way you simply it, you are doing a great job please keep it up
So I have just had this job and I produce Same report every week. I am curious to know how I can fit in macros from copy pasting from the accounting software xero into excel. If there is any course you have I am happy to sign up as this will help save loads of time. I have tried recording macros however, it does not work, when I come to produce the reports.
Hi Leila, thanks for this video. This really helped me a lot to understand how Macro works. I just have one question, what if we add new rows from NewData#1 and 2 will the macro will capture the new rows in SummaryData sheet? I’m trying to create a running file from different sheets and integrate it in one sheet
Hello, really good. Thanks a lot.
Is there anyway to add Macro for the sheets will be added in future? For example monthly sheets done until August but will be added until December later o
Hey Leila, is the course on Udemy has the same content you provide on XelPlus??
The video content is the same. The additional bonuses listed on XelPlus are not available anywhere else.