Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone please help me!!! i keep getting stuck at step 5 Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small

can someone please help me!!! i keep getting stuck at step 5 image text in transcribed
image text in transcribed
Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small start-up company that deals with sports memorabilia As you prepare to document your inventory, you decide to utilize a template to save time. To complete this task you will create a worksheet based on an Office, com template, you will no use the Muaro Recorder and Visual Basic for Application to nutomate sorting and calculations within the workbook Steps to Perform: Step Points Possible 1 0 2 4 3 0 4 4 5 O Instructions Start Excel. Download and open the file named EP 19_Excel_Ch12_Cap_Inventory xdex. Grader has automatically added your last name to the beginning of the filename Delete the inventory Pick List and Bin Lookup worksheets. Delete the INVENTORY PICK LIST and BIN LOOKUP icons located respectively in cells E2 and F2. Then Clear all existing Dute Validation in the range A1:K16. Delete the values in the range B6.J15. Record a macro named Sort, be sure to use relative references Ensure the macro sorts the data in the table in ascending order based on SKU (column A). Stop the Macro Recorder and Save the workbook as a Macro-Enabled Template Create a form control button that spans the cell E2 E3. Assign the Sort macro and edit the button text to Sort Use the VBA Editor to create a new module. Type the following VBA code to create a custom inventory Value function then save and excit the VBA Editor (be sure to leave a blank line between each line and before End Function Function doucentaxe. (QTY, COST) boxentaryXalua - QTY. COST 8 2 7 O 8 9 Click cell 35 and use the newly created twenta alue function to calculate the value of the inventory for each item in column 1 Use the VBA Editor to create a new module named PastertillonshoekType the following VBA statements to create the sub procedure (leave appropriate line spacing) o Sub Protected "Protect workbook using the password exploring Worksheets("inventory List Protect Password - Xalacing Points Possible Instructions Step 0 10 Insert a new module named LontotectMarkook. Type the following VBA statements to create the sub procedure and then save and edit the VBA Editor (leave appropriate line Spacing) Sub Lowestelakook 2 11 2 12 Unprotect workbook using the password exploring Worksheets("inventory List").Unprotect Password:=eXploring Insert a Form Control Button spanning cells F2F3 named Unprotect Assign the Lontestobook macro to the newly created Control Button Insert a Form Control Button spanning the range G2H3 named Protect Assign the macro ProtectWedback Insert the comment Inventory based on values in column J. in cel B3 [include the period) Insert the comment Count of items in column C in cell C3 [include the period) Inspect the document for private information and hidden properties Save the file when prompted then remove Document Properties and Personal Information, and Headers and 9 13 e 14 D 15 Footers 0 18 Note: Mwo users, from the Excel menu open your preferences, click Security, and then click the check box to Remove personal information from this file on save Delete any headers or footers in the workbook Check the document for accessibility issues. Use the Accessibility Checker pane to change the cell styles to Normal in order to repair the issue Check the document for compatibility with Excel 2010, 2013. and 2016 Note: Mac users, skip this step 17 0 18 Insert a new worksheet named Code 10 19 10 20 10 Open the VBA Editor, open Module 1, and copy the code Paste the code in the Code worksheet starting in cell A1 In the VBA Editor, epun Module 2 and copy the code Faste the code in the Cose worksheet starting in cell A22 In the VBA Editor, open the Festestockhook, and copy the code. Paste the code in the Code worksheet starting in cell A23 In the VBA Editor open the Westerstock module and copy the code Paste the code in the Code worksheet starting in cell A25 21 10 22 10 23 Close the VBA Editor and save the workbook as an ex file inot Macro-Enable) 24 Close EXP19 Excel Ch12 CAP Inventor Edt Excel Submit the sle as directed Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small start-up company that deals with sports memorabilia As you prepare to document your inventory, you decide to utilize a template to save time. To complete this task you will create a worksheet based on an Office, com template, you will no use the Muaro Recorder and Visual Basic for Application to nutomate sorting and calculations within the workbook Steps to Perform: Step Points Possible 1 0 2 4 3 0 4 4 5 O Instructions Start Excel. Download and open the file named EP 19_Excel_Ch12_Cap_Inventory xdex. Grader has automatically added your last name to the beginning of the filename Delete the inventory Pick List and Bin Lookup worksheets. Delete the INVENTORY PICK LIST and BIN LOOKUP icons located respectively in cells E2 and F2. Then Clear all existing Dute Validation in the range A1:K16. Delete the values in the range B6.J15. Record a macro named Sort, be sure to use relative references Ensure the macro sorts the data in the table in ascending order based on SKU (column A). Stop the Macro Recorder and Save the workbook as a Macro-Enabled Template Create a form control button that spans the cell E2 E3. Assign the Sort macro and edit the button text to Sort Use the VBA Editor to create a new module. Type the following VBA code to create a custom inventory Value function then save and excit the VBA Editor (be sure to leave a blank line between each line and before End Function Function doucentaxe. (QTY, COST) boxentaryXalua - QTY. COST 8 2 7 O 8 9 Click cell 35 and use the newly created twenta alue function to calculate the value of the inventory for each item in column 1 Use the VBA Editor to create a new module named PastertillonshoekType the following VBA statements to create the sub procedure (leave appropriate line spacing) o Sub Protected "Protect workbook using the password exploring Worksheets("inventory List Protect Password - Xalacing Points Possible Instructions Step 0 10 Insert a new module named LontotectMarkook. Type the following VBA statements to create the sub procedure and then save and edit the VBA Editor (leave appropriate line Spacing) Sub Lowestelakook 2 11 2 12 Unprotect workbook using the password exploring Worksheets("inventory List").Unprotect Password:=eXploring Insert a Form Control Button spanning cells F2F3 named Unprotect Assign the Lontestobook macro to the newly created Control Button Insert a Form Control Button spanning the range G2H3 named Protect Assign the macro ProtectWedback Insert the comment Inventory based on values in column J. in cel B3 [include the period) Insert the comment Count of items in column C in cell C3 [include the period) Inspect the document for private information and hidden properties Save the file when prompted then remove Document Properties and Personal Information, and Headers and 9 13 e 14 D 15 Footers 0 18 Note: Mwo users, from the Excel menu open your preferences, click Security, and then click the check box to Remove personal information from this file on save Delete any headers or footers in the workbook Check the document for accessibility issues. Use the Accessibility Checker pane to change the cell styles to Normal in order to repair the issue Check the document for compatibility with Excel 2010, 2013. and 2016 Note: Mac users, skip this step 17 0 18 Insert a new worksheet named Code 10 19 10 20 10 Open the VBA Editor, open Module 1, and copy the code Paste the code in the Code worksheet starting in cell A1 In the VBA Editor, epun Module 2 and copy the code Faste the code in the Cose worksheet starting in cell A22 In the VBA Editor, open the Festestockhook, and copy the code. Paste the code in the Code worksheet starting in cell A23 In the VBA Editor open the Westerstock module and copy the code Paste the code in the Code worksheet starting in cell A25 21 10 22 10 23 Close the VBA Editor and save the workbook as an ex file inot Macro-Enable) 24 Close EXP19 Excel Ch12 CAP Inventor Edt Excel Submit the sle as directed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions