MM0044 - 05/10/20 - Improving A Live Excel File With VBA
In this session, we focus on a real-life application of Excel sent in by Nikki. We talk through the file and begin to implement some VBA to speed things up.
Topics
Topics
- | Nikki Tells Us About Her Excel Learning
- | Quick Briefing On Nikki's Project
- | You Won't Understand It All!
- | How To View All Sheets In The File
- | How To Transpose Data
- | UNIQUE
- | Use COUNTIF To Validate A Dataset
- | Do A Multi-Level Sort
- | Prepare For Application.WorksheetFunction
- | Application.WorksheetFunction.Countif
- | How To Understand The Concept
- | Comparison To 'Looping Through' Data
- | Subscript Out Of Range
- | Find Row Number Of First Entry
- | Recycle Existing Code Example
1 Lesson