You are the operations manager for Bulldog Collectables, a small start-up company that deals with sports memorabilia. As you pre-pare 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 also use the Macro Recorder and Visual Basic for Application to automate sorting and calculations within the workbook. Select and Edit a Template You want to download a warehouse inventory template. Once downloaded, you will edit the content to fit your business needs. 1. Open Excel and search the template gallery for the Warehouse inventory template.
2. Create a new document based on the template and save it as a Macro-Enabled Template named e12c1Inventory_LastFirst. xltm.
3. Delete the Inventory Pick List and BIN Lookup worksheets.
4. Delete the Inventory Pick List and BIN Lookup icons located respectively in cells E2 and F2. Select the range E2:F2 and press Delete.
5. Clear all existing Data Validation in the range A1:K15.
6. Delete the values in the range B5:K15
7. Save the template.
Create the Sort Macro
You want to create a macro that will sort the desired data in one click. To complete this task, you will use the Macro Recorder and assign the macro to a Button Form Control.
8. Record a macro named Sort, be sure to use relative references.
9. Ensure the macro sorts by sku (column A) in ascending order.
10. Create a Form Control Button that spans the range E2:E3.