Data Science Examples
Excel and VBA
I really like Excel – there are many Data Analytics programs out there, but you would be surprised at how far you can get with Excel.
Here’s a Macro I made with both the Record Macro and VBA function. Basically this Macro:
- Adds and formats headers to as many worksheets as you have
- Sums the total of the last row in each worksheet
- Pastes all those worksheets in an empty worksheet at the end.
Download the zipped Microsoft XLSM file and a text file of the Visual Basic code here. Be sure to enable Macros in the Excel file so that you can run the Macro.