Manually create a data table exactly as shown in Table 2 into worksheet "Prob2". You can format the cells manually (i.e., not via code) in Excel. The upper left corner of Table 2 (i.e., the label "FlightNo") should be entered in cell B2.

SOLUTION REQUIREMENTS 1. 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 A1. 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 B10. 2. Write a sub procedure named Clear_Table that will clear the range J2:O7. Assign the sub procedure Clear_Table to a rectangular shape button. The caption of the rectangular shape button should read Clear. The rectangular shape button should be visually appealing and its upper left corner should be aligned with the upper left corner of cell E10.

I think I have a genaral idea but would love to see someone solve this with code and use it compared to mine.

Table 2. Data for Problem 2 Destination TotalSeats TravelTime htNoAirline 2345 1864 Virgin America Orlando 2297 3275 4325 7 hours 5 hours 5 hours 8 hours 6 hours Orlando Los 90 120 100 120 United Delta T Miami St Louis Tallahassee San Atlanta Austin