The Multi Year Stock Market file is too large, the first VBA script was only for one spreadsheet and created on the alpha_testing spreadsheet.

Modify the script to be able to work on multiple sheets. Saved the script as "single" and "multi" .bas files: [Alpha_testing_single.bas], [Alpha_testing_multi.bas]

Import the script to the Multi Year Stock Market file and let the VBA magic begin!

Please see the summary table in the alphabetical testing file, you'll find the informaiton below,

• Ticker: Stock name

• Yearly change: Difference between the opening price at the beginning and the closing price at the end of that year; all the positive changes are highlighted in green, and all the negitive changes are highlighted in red.

• The percent change: the percentage of the yearly change of that given year.

• The total volume: the total volume of the stock of that given year.

• The Greastest % Increase: the highest growth stock of that given year.

• The Greastest % Decrease: the lowest growth stock of that given year.

• The Greatest total volume: the highest transation volume stock of that given year.

• The image of the result of the Multi Year Stock Market data attached as follow: [2014 Stock Market.png], [2015 Stock Market.png], [2014 Stock Market.png]