Skip to content

Latest commit

 

History

History
11 lines (9 loc) · 572 Bytes

README.md

File metadata and controls

11 lines (9 loc) · 572 Bytes

VBA-challenge

Module 2 Challenge

This repository contains the BAS file (VBA script) for the assignment and screenshots of the completed spreadsheet that results after running the file.

The file consists of: Declarations Headers Loop to write to a table consisting of one row for each stock and its change over one year as well as the total volume Another loop to the summary table shows the greatest percentage increase in value and volume and the least-performing stock in terms of value. In addition, this script will complete the entire workbook at once.