Write a Visual Basic Code in Excel

A company sells 3 types of product, p1, p2, and p3. In the following table, i present the transactions table where the manager of this company keeps track of the last month's transaction. Create a subroutine that allows the manager to calulate the total sales (in $) by product and present the results on the corresponding cells of the excell spreadsheet. Assign this subroutine to the command button called "Calculate." (which is the white button in the photo below)

Problem 5: A company sells 3 types of product, pl, p2 and p3. In the Lab 2 file, Problems sheet, I present the transactions table where the manager of this company keeps track of the last month's transaction. Create a subroutine that allows the manager to calculate the total sales in ) by product and present the results on the corresponding cells of the excel spreadsheet. Assign this subroutine to the command button called "Calculate." Total Sales by product p2 p3 p1 Transaction Product 1 pl 2 p2 3 p3 4 p2 5 p1 6 p2 7 p3 8 pl 9 pl 10 pl p3 12 p3 13 p2 14 pl 15 p3 16 pl 17 p3 18 p2 19 pl 20 p3 21 p1 22 p2 23 p3 24 pl Sales (in s) 147 170 191 190 143 181 166 125 179 196 179 116 194 196 151 108 124 136 109 140 174 170 109 133