A viewer of businessprogrammer.com wanted to know how to consolidate Microsoft Excel data downloaded from a web portal using a visual basic for applications (vba) macro. Excel VBA book (affiliate) with reviews https://amzn.to/3axlqih This tutorial will demonstrate how I merge excel spreadsheets and consolidate this data into a single worksheet for uploading to another system, in this instance an accounting system. I cover topics such as grabbing vba ranges without using select with vba, using .offset and .resize, using collections and nesting collections inside of arrays, use of the locals window in the vba editor, using vba to combine multiple files into one and much more. Get the spreadsheets and code that go with this tutorial at this link https://www.businessprogrammer.com/excel-vba-consolidate-data-from-multiple-sheets/. ☕ If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson ☕ Video Production =============== Sony Camera: https://amzn.to/3mqyqfu Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum Microphones --------------- Screen Casting: https://amzn.to/3a2TnHN Microphone and Arm : https://amzn.to/3iwvL2S Talking To Camera: https://amzn.to/3FqXI6b Video Kit ------------- Lights Elgato video Lights: https://amzn.to/3sSK3xg Background Light: https://amzn.to/3uTXyPh Note Taking -------------- Rocketbook reusable notebook https://amzn.to/3sSK3xg DISCLAIMER: This video and description contains affiliate links, this means if you click on one of the product links, I’ll receive a small commission.