SOLUTION REQUIREMENTS

a$.$ The Offset property MUST be used to position all the row and column labels in the summary

data table $($e$.$g$.,$ "Vessel Calls" and "Minimum"$).$ You may use any cell in the worksheet "Prob$1"$

as the base cell $($i$.$e$.,0^{th}$ row and $0^{th}$ column cell$)$ when using the $0^{ff\text{s}\text{e}\text{t}}$ property. The numerical

values in the summary table can be positioned in the table using any Excel VBA property you

deem appropriate.

b$.$ The sub procedure Summary$\_$Table must comply with the following formatting requirements of

the summary table:

Row labels must be BOLD, Italic, BLUE, and left aligned.

Column labels must be BOLD, RED, and centered.

The interior color of every other column should be changed to improve readability. You are

at liberty to pick the interior color. Note that Black and White are NOT acceptable colors to

fulfill this requirement.

Borders around the cells must be created via code using a continuous line style and a thin

weight.

c$.$ The following formulas must be used to perform the calculations for each row category in the

summary table $($see Figure $1)$:

MIN

AVERAGE

MAX

SUM

d$.$ The display of every column of the summary table $($and corresponding formats$)$ should occur

with a delay of one second from each other. For example, once the procedure Summary$\_$Table

is executed, the display of the column that contains the row labels in the summary table $($e$.$g$.,$

Vessel Calls, Total Tonnage, etc.$),$ and corresponding formats should be displayed after one

second. Then, another second must elapse before the data in the column labeled "Minimum" are

displayed, and so on$.$

e$.$ Column widths MUST adjust automatically to its contents after each column is displayed.

f$.$ Range I$2$:M$12$ should be cleared automatically by your procedure immediately after the

rectangular shape button is pressed.

g$.$ You must use the WITH construct to make your code more readable.

h$.$ Your sub procedure must end by selecting cell A$1.$

Write a single sub procedure named Summary$\_$Table that will process the data in Table $1$ to create the summary table depicted in Figure $1.$

Please use basic VBA code and Comment your code aswell. I will Like when the work is done and please test the code to see if if it works correctly as well as follows the guidlines. Thank you so much this has been a headache.