#VBA-challenge

Project Overview

This project contains VBA macros for analyzing stock data across multiple quarters. The VBA script automates the following tasks:

• Calculating quarterly changes in stock prices.
• Determining the percentage change and total volume of stocks.
• Highlighting positive and negative changes with conditional formatting.
• Generating reports on the greatest percentage increase, decrease, and total volume of stocks.

Usage

• Stock Data Sheets: Each worksheet in the workbook represents a different quarter of stock data.

• Analysis: The VBA script calculates and displays:

  • Quarterly changes in stock prices.
  • Percentage change and total stock volume.
  • Highlights changes using conditional formatting.
  • Reports the greatest percentage increase, decrease, and total volume.