SOLUTION REQUIREMENTS

Write a sub procedure named Sort$\_$Flight$\_$Information that will:

a$.$ Use the End property of the Range object to copy and paste the data in Table $2.$ The upper left

corner of the copied data $($i$.$e$.,$ the label "FlightNo"$)$ should be pasted in cell $J2.$

b$.$ Sort the data in the copy of Table $2$ in ascending order alphabetically by Airline $($use the Sort

method of the Range object$).$

c$.$ Use the Rows property of the Range object to give every other row in the sorted copy of Table $2$

its own background color. You are at liberty to pick the color from Red, Blue, Green, Yellow,

Cyan, and Magenta $($Black and White are NOT acceptable colors to fulfill this requirement$).$

d$.$ Ensure that no revolving border remains after executing any copy$-$pasting operations.

e$.$ Ensure that no flickering occurs when you run your sub procedure.

f$.$ End the sub procedure by selecting cell A$1.$

Assign the sub procedure Sort$\_$Flight$\_$information to a rectangular shape button. The caption of

the rectangular shape button should read "Sort by Airline". The rectangular shape button should be

visually appealing and its upper left corner should be aligned with the upper left corner of cell B$10.$

Write a sub procedure named Clear$\_$Table that will clear the range J$2$:$07.$ 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.