Hwan created a macro named CopyStats to copy the project statistics in the range 13:L22, and then paste them on a new worksheet. When he runs the Copy Stats macro, however, it includes extra data from column G. View and edit the macro as follows: Open the CopyStats macro in the Visual Basic Editor. The macro should select and copy the range 13:122. b. In the CopyStats macro VBA code, change the range specified in the first line of code after the comments (Range("G3:L22").Select) to use 13:L22 as the range. C. Save and close the CopyStats macro. d. Run the CopyStats macro. e. Use Project Stats as the name of the new worksheet the macro created. Home Insert Draw Page Layout Formulas Data Review View Developer Share Comments to record macro Record Macro von N21 19 Aa ESO A Visual Macros Basic Use Relative References Add-ins Excel Add-ins Button Group Combo Label Check Scroll Box Box Box Bar List Option Spinner Box Button Yes No | H1 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? x v fx B C D E F G H I J K L M N O P Q R S T W&K Engineering Projects Print Stats Projects Total Estimates Avg Estimates Category Bridge Highway Paving Site development Estimate >50,000 Projects: Paving Client ID W-0338 Total paid: 3 Client ID Project Type Category - State 4 W-0338 Attenuators Highway NE 5 W-0341 Signage Highway NE 6 W-0277 Grade crossing Bridge WY 7 W-0290 Erosion control Site development NE 8 W-0344 Noise abatement Site development SD 9 W-0185 Cold planing Paving ND 10 W-0338 Abutments Bridge NE 11 W-0322 Off-road rest area Site development WY 12 W-0290 Hydraulic fill Site enhancement NE 13 W-0327 Patching ND 14 W-0332 Ramps Paving MT 15 W-0338 Seal coating Paving NE 16 W-0364 Seal coating Paving SD 17 W-0132 Highway grading Paving MT 18 W-0277 Grade separation Bridge WY 19 W-0185 Curbing Paving ND 20 W-0332 Patching Paving MT 21 W-0358 Shoulders Paving MT 22 W-0284 Median strip Highway SD 23 W-0360 Resurfacing Paving NE 24 W-0322 Grading Site development 25 W-0185 Patching Paving ND 26 W-0332 Abutments Bridge MT 27 W-0284 Attenuators Highway 28 W-0379 Signage Highway ND 29 W-0344 Erosion control Site development SD 30 W-0338 Curbing Paving NE 31 W-0358 Attenuators Highway Documentation Projects Projects by State Ready T Project Start 1/12/21 1/20/21 2/16/21 2/22/21 2/22/21 3/1/21 3/12/21 3/20/21 3/23/21 3/24/21 3/30/21 4/2/21 4/2/21 4/5/21 4/5/21 4/14/21 4/16/21 4/16/21 4/17/21 4/23/21 5/2/21 5/10/21 5/14/21 5/14/21 5/26/21 5/30/21 6/1/21 6/3/21 Estimate- $30,562 $14,500 $54,672 $107,654 $38,750 $48,932 $72,358 $24,505 $34,756 $68,900 $42,350 $27,800 $28,500 $70,347 $19,576 $78,400 $76,320 $52,050 $56,890 $34,560 $19,750 $34,566 $29,800 $24,528 $18,500 $85,437 $82,350 $31,250 Paid to Date $30,562 $12,000 $50,000 $57,654 $30,000 $45,932 $72,358 $24,505 $34,756 $34,900 $4,250 $17,000 $28,500 $30,400 $10,576 $38,400 $16,320 $12,050 $6,000 $17,000 $2,000 $24,000 $20,000 $2,400 $18,500 $43,000 $40,000 $11,250 Projects by State | ND 000 WY SD MT Project Payments Projects by Category Monthly Sales Employees Expansion Loan + Investments & Projections 0 -- + 120% Hwan created a macro named CopyStats to copy the project statistics in the range 13:L22, and then paste them on a new worksheet. When he runs the Copy Stats macro, however, it includes extra data from column G. View and edit the macro as follows: Open the CopyStats macro in the Visual Basic Editor. The macro should select and copy the range 13:122. b. In the CopyStats macro VBA code, change the range specified in the first line of code after the comments (Range("G3:L22").Select) to use 13:L22 as the range. C. Save and close the CopyStats macro. d. Run the CopyStats macro. e. Use Project Stats as the name of the new worksheet the macro created. Home Insert Draw Page Layout Formulas Data Review View Developer Share Comments to record macro Record Macro von N21 19 Aa ESO A Visual Macros Basic Use Relative References Add-ins Excel Add-ins Button Group Combo Label Check Scroll Box Box Box Bar List Option Spinner Box Button Yes No | H1 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? x v fx B C D E F G H I J K L M N O P Q R S T W&K Engineering Projects Print Stats Projects Total Estimates Avg Estimates Category Bridge Highway Paving Site development Estimate >50,000 Projects: Paving Client ID W-0338 Total paid: 3 Client ID Project Type Category - State 4 W-0338 Attenuators Highway NE 5 W-0341 Signage Highway NE 6 W-0277 Grade crossing Bridge WY 7 W-0290 Erosion control Site development NE 8 W-0344 Noise abatement Site development SD 9 W-0185 Cold planing Paving ND 10 W-0338 Abutments Bridge NE 11 W-0322 Off-road rest area Site development WY 12 W-0290 Hydraulic fill Site enhancement NE 13 W-0327 Patching ND 14 W-0332 Ramps Paving MT 15 W-0338 Seal coating Paving NE 16 W-0364 Seal coating Paving SD 17 W-0132 Highway grading Paving MT 18 W-0277 Grade separation Bridge WY 19 W-0185 Curbing Paving ND 20 W-0332 Patching Paving MT 21 W-0358 Shoulders Paving MT 22 W-0284 Median strip Highway SD 23 W-0360 Resurfacing Paving NE 24 W-0322 Grading Site development 25 W-0185 Patching Paving ND 26 W-0332 Abutments Bridge MT 27 W-0284 Attenuators Highway 28 W-0379 Signage Highway ND 29 W-0344 Erosion control Site development SD 30 W-0338 Curbing Paving NE 31 W-0358 Attenuators Highway Documentation Projects Projects by State Ready T Project Start 1/12/21 1/20/21 2/16/21 2/22/21 2/22/21 3/1/21 3/12/21 3/20/21 3/23/21 3/24/21 3/30/21 4/2/21 4/2/21 4/5/21 4/5/21 4/14/21 4/16/21 4/16/21 4/17/21 4/23/21 5/2/21 5/10/21 5/14/21 5/14/21 5/26/21 5/30/21 6/1/21 6/3/21 Estimate- $30,562 $14,500 $54,672 $107,654 $38,750 $48,932 $72,358 $24,505 $34,756 $68,900 $42,350 $27,800 $28,500 $70,347 $19,576 $78,400 $76,320 $52,050 $56,890 $34,560 $19,750 $34,566 $29,800 $24,528 $18,500 $85,437 $82,350 $31,250 Paid to Date $30,562 $12,000 $50,000 $57,654 $30,000 $45,932 $72,358 $24,505 $34,756 $34,900 $4,250 $17,000 $28,500 $30,400 $10,576 $38,400 $16,320 $12,050 $6,000 $17,000 $2,000 $24,000 $20,000 $2,400 $18,500 $43,000 $40,000 $11,250 Projects by State | ND 000 WY SD MT Project Payments Projects by Category Monthly Sales Employees Expansion Loan + Investments & Projections 0 -- + 120%