Use the following videos to help you get set up in Excel with Visual Basic
Video 1: Enabling the Developer Tab in Excel, Creating a VB Script, Executing and Saving a VB Script and Macro Enabled
Workbook
Video 2: Using Sheet references as Variables in VBA Scripting
Files created in this video:
demo01.xlsm
demo01.vbs
Video 3: Using Sheet references as Variables in VBA Scripting and Doing Calculations in different sheets
Files created in this video:
cereal.xlsm
demo02.vbs
Video 4: Using Sheet references as Variables in VBA Scripting and Doing Calculations in different sheets using Aggregates (part 1)
Files created in this video:
armada.xlsm
demo03.vbs
Video 5: Using Sheet references as Variables in VBA Scripting and Doing Calculations in different sheets using Aggregates (part 2)
Files created in this video:
USpopulation.xlsm
demo04.vbs
Video 6: Wells Fargo Demo (part 1)
Files created in this video:
combined_wells_fargo.xlsm
demo05.vbs
Video 7: Wells Fargo Demo (part 2)
Files created in this video:
combined_wells_fargo.xlsm
demo06.vbs