Learn Excel Reporting Automation For Beginners with Excel VBA (Code Included)

Excel VBA makes a amazing tool to automate reporting. If you work in Accounting or Finance, then being able to create a macro to automate a reporting that usually takes half hour to merely just a minute, and you can re-use the the program over and over again, is going to be a huge time and energy saver.
Excel VBA is the programming language to automate Excel spreadsheet, and the beauty with VBA is that, it is actually pretty easy to pick it up. Excel application on the other hand, is the most widely used spreadsheet in the world today.
In this tutorial I am going to teach you how to start learning automating a reporting process using Excel VBA. You don't have to be an expert in Excel programming, but it is ideal that you have at least have a little bit experience writing macro (Excel VBA).
► Download VBA source code
learndataanaly...
► Download exercise file
drive.google.c...
► To Enable Developer Tab: • Video
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood...
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → / madeinpython
📘 More tutorial videos on my website → LearnDataAnaly...
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: [e-mail]
#ExcepReporting #ExcelAutomation

[@karladuenas1482]

Thanks for sharing. I don't have a background in computer science but I am so thankful for you posting this video as I am interested in learning. Thank you

[@bryanbertrand5400]

Thank you for the video. How do I get the code for the "Learn Excel Reporting Automation For Beginners with Excel VBA (Code Included)". Thanks in advance

[@jaswantdn7]

Amazing work...thank you..

[@hansakaerandaranasinghe6455]

Dear Jie Jenn Pls advise how this method works on PDF File type.

[@ricardoromo96]

when exporting the files, is there a way to rename the Sheet1 to also be the file name?

[@durbeshkumar4126]

Thanks Sir your video very useful..

[@Argo007-r4s]

thanks for sharing

[@yuslanld7956]

Thanks very much

[@millsathn]

Nice!

[@moesadr3342]

I have a dynamic database table with many columns and rows and would like to be able to create a printable report whenever needed. The report needs to be showing only a few columns and those records who have certain criteria ( filtered). Like the stage is "Open" and Rank is " A", and the project value is over $1000, ....etc. Wondering if you might have a template to share. Please advise.

[@mapranav]

did u find a template?

[@moesadr3342]

@@mapranav I am afraid not yet

[@richardramos4507]

Hi, did you find a template or a helpful documentation for creating this request ? I'm in a similar position

[@omgLEWISnKreh]

I can't download the file to follow along. Wish this can be fixed. Otherwise, splendid video!

[@jiejenn]

Thanks for letting me know. You can download the exercise data file here
drive.google.com/uc?export=download&id=1yrpbDopWZQrln7FMGuhhJxnR6A91KBMM

[@Argo007-r4s]

why am i getting error on Const it is said Not allowed on public members of object modules

[@jiejenn]

Without look at your script, I am going to guess there is a typo somewhere.

[@Argo007-r4s]

@@jiejenn I just try copy from your code and Your Data set and it happened the Macro Code won't run beacuse Const said not allowed on public members, Pls help

[@avinashkhilari1934]

Pls share VBA code

[@hh0686]

Hi I tried to replicate by using your vba codes, but one issue is the output files are generated in one folder level up.
I created a folder C:\Users\user\Downloads\Practice Excel\Output but instead the output files generated in C:\Users\user\Downloads\Practice Excel
I used C:\Users\user\Downloads\Practice Excel\Output in line 7:
Public Const Output_Folder_Path As String = "C:\Users\user\Downloads\Practice Excel\Output"

[@hotelrus]

You are very good at coding, but very bad at teaching.

[@jiejenn]

Thanks for your feedback. Still learning how to improve since 2019.

[@hotelrus]

@@jiejenn what I meant is the way you teaching is not for newbies. It would be helpful if you could explain every single piece of code with more examples. Maybe I'm wrong though. Keep on moving brother, overall it is a nice tutorial.

[@jiejenn]

@@hotelrus I see. My tutorials are mostly aiming for experienced coders since there are already so many tutorials out there gearing toward beginners. I am trying not to reinvent the wheel.