Using Workbook VBA Cell Manipulation.xlsx

On Sheet 2 and Write a macro

Select the inner contents (i.e. no headers and player names) of the table on Sheet 2, using the opposite corner method

Use .clear to clear Cell B2 on Sheet 2

Write a macro that inserts formulas into Cell G2 that compute the median divided by maximum (Range(C2:C7)) and make G2 bold

On Sheet 1

Use .Cell to select the Cell D4

Use .End to select the whole table

Create the Header Name with MyHeader and make header bold and center. The font size is 14

Submit .xlsm file