Skip to content

mark-helotie/vba-challenge

Repository files navigation

vba-challenge

Submission #2 for Data Analysis bootcamp

The VBS and the matching TXT file are the same... I only included .TXT to get around any security issues with "ability to download VBS" as a virus etc.

The script will cycle thru each tab, and it puts a summary page on EACH worksheet (for that data on that tab).

From the small "sample" file... here is a sampling of my output:

image image

And from the HUGE 2018/2019/2020 file:

image image image

Note that I did some additional (above and beyond) formatting... added "," in the volume columns, bold column headers, etc. All within the VB code.

About

Submission #2 for Data Analysis bootcamp

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published