-
Notifications
You must be signed in to change notification settings - Fork 0
VBA analysis of a 22M record dataset.
License
danawoodruff/Excel-VBA
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
The code analyzes appx 22 million rows of data to retrieve and calculate data points.
* Retrieval and calculation is accomplished with five procedures utilizing functions, e.g., AdvancedFilter and XLookup.
* A sixth procedure loops each worksheet through the previous five procedures.
* A user form was created to prompt the user to begin calculations. When calculations have finished after 30-40 seconds it disappears.
About
VBA analysis of a 22M record dataset.
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published