67,482 views
CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE VBA COURSE: https://lp.hashtagtreinamentos.com/es... DOWNLOAD THE FREE VBA MINI COURSE: https://bit.ly/2Lfssfa To receive daily Excel, Microsoft Excel VBA and Power BI content for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos we teach several Excel VBA tips and Excel VBA tricks so that you can develop in this tool! ----------------------------------------------------------------------- ► Spreadsheet used in the video: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ----------------------------------------------------------------------- TOP Videos: ► Excel VBA Macros - How to create a Macro from Scratch • Excel VBA Macros - How to create a Mac... ► How to create a form in Excel - Creating Userform in VBA - 1/5 • How to create a form in Excel - Crea... ► VBA - What is VBA? What are Macros? • VBA - What is VBA? What are Macros? ► Record Macro - Practical Mini-Course on Macros and VBA (1/10) • Record Macro - [Practical Mini-Course on ... ► First Empty Line - Practical Mini-Course on Macros and VBA (8/10) • First Empty Line - [Practical Mini-Course on ... ----------------------------------------------------------------------- In this class I will teach you how to import data from another worksheet in VBA! In the example of today's class we have two different worksheets. The first has our query and the second our stock. What we want to do is copy data from one worksheet to another VBA worksheet every time a query is made. In order to perform this import, we will need to use the VBA Workbooks Object, which allows us to work with worksheets. Using this object, importing data from another Excel VBA worksheet will be very fast, easy and simple to do! ----------------------------------------------------------------------- #excel #vba #hashtagtraining