help last min hmk

Office 2010 – myitlab:grader – Instructions Exploring Series Vol. 2, Chapter 11, IRCD

Property Sort Macro

Project Description: In this project you will create a macro that copies and pastes a range of formatted Property data into a different sheet. The macro will sort the data by three fields and set up the data to be printed. You will create a command button, attach the macro to it, and then run the macro from the button.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save and open the Excel workbook named Exploring_e11_Grader_IR.xlsm. 0 2 Apply the Civic theme to the workbook. 8 3 In the Sold Properties sheet, select the range A1:H1 and create a custom cell style named My_Heading. Modify the selected formatting to Bold Italic, font size 12 pt, and the fill color to light blue (seventh column, bottom row). Apply the My_Heading style to the range A1:H1. 12 4 Begin to create a macro named Property_Sort in this workbook. Accept the default settings in the dialog box. While recording the macro, be sure to follow the steps exactly as specified. Do not switch between windows or worksheets in between steps. 10 5 In recording mode, on the Sold Properties sheet, select the range A1:H25. Copy the selected range, and then paste it starting in cell A1 of the Sorted Data sheet. 10 6 In the Sorted Data sheet, create a multi-level custom sort. First sort by City in ascending order. Add a sort level to sort by Subdivision (ascending), and then sort by Beds in descending order. 15 7 Set the left and right margins of the Sorted Data sheet to 0.5 inches each and adjust the scaling to 75% of normal size. 6 8 Use the Go To command to go to cell A1 of the Sold Properties sheet. Stop recording the macro. Print preview the Sorted Data worksheet to see how it displays. 8 9 In the Sold Properties sheet, draw a Form Control button from cells I3:J4. Assign the button to run the Property_Sort macro. Set the caption of the button to Sorts Data, the height to 0.5", and the width to 1.5". 12 10 In Excel, on the Sorted Data sheet, delete the data (but not the formatting) in the range A1:H25. Return to the Sold Properties sheet and deselect Design Mode for the button, if necessary. Click the Sorts Data button to run the macro and ensure that the macro works as expected. In the Microsoft Visual Basic for Applications window, delete any empty comment lines or blank lines in the code, and then copy the entire Property_Sort macro from the Sub statement to the End Sub statement inclusive. Paste the code into cell A1 of the Code sheet in this workbook (the VBA code will appear in cells A1:A81 when pasted). 19 11 Save the macro-enabled workbook as an Excel workbook, using the same file name. Click Yes to save it as a macro-free workbook. Close the workbook. Exit Excel. Submit the Exploring_e11_Grader_IR.xlsx workbook as directed. 0 Total Points 100

Updated on: 12/28/2010 1 E_CH11_EXPV2_IRCD_Instructions.docx