macro excel
macro needs to be found in submitted file ( save file as .xlsm – macro-enabled)
Document Preview:
1/20/2009 6 70 12/15/2008 7 70 1/20/2009 8 70 1/20/2009 9 70 11/30/2008 6 85 12/15/2008 7 85 1/20/2009 8 85 12/15/2008 9 85 12/15/2008 8 125 11/30/2008 9 125 11/30/2008 10 125 10/20/2008 11 125 10/20/2008 12 125 10/20/2008 8 185 11/30/2008 9 185 11/30/2008 10 185 9/18/2008 11 185 9/18/2008 12 185 UMUC-KK/JP 11/20/2008 7 70 1/6/2009 10/26/2008 8 185 1/30/2009 3/19/2008 8 85 2/15/2009 UMUC-KK/JP Listed Price Date Sold Description Location Case B Case C Material Marcson’s Jewelry Inventory Listing – Rings Size Silver Oval, Pink Crystal, Wms Item Number Mfg Dawson AAK202010015 Six Petal Violet Flwr Crystal, Wms Teller Square Black Crystal, Mns AAK202000013 AA0330004551 Luson Mercy Silver/Gold Plate AAK201980012 AAK201980013 AAK201980014 AAK201980015 AAK201980016 Grey Agate, Mns FIN 615 – Macro Problem 1 Marcson Jewelry keeps their inventory based on specific identification. Everytime a ring is sold, the bookkeeper records the move from inventory to sales on an inventory worksheet. Currently he copies and pastes the items sold from one spreadsheet to another. He would like to automate the process by using a macro. To assist, you, as the Controller, have written a macro to perform the task. Follow the steps below. Create the macro and test that it works. You may use this Excel file as the starting place for your work. Feel free to edit its design or formatting as you see fit for your preferred presentation. Document (map) your workbook for the bookkeeper how to run the macro. Remember to name your saved file according to the file naming directions in the syllabus. For this example, we will assume we are reconciling March 2009 sales. 1) Type 3/12/2009 into cell I16 of the Listings worksheet and press ENTER. This entry records the date of the sale of this item. 2) Select row 16 by clicking its row number heading. This is the row we will transfer to the SALES spreadsheet. 3) Select Developer, R ecord Macro. The record Macro dialog box appears….
1/20/2009 6 70 12/15/2008 7 70 1/20/2009 8 70 1/20/2009 9 70 11/30/2008 6 85 12/15/2008 7 85 1/20/2009 8 85 12/15/2008 9 85 12/15/2008 8 125 11/30/2008 9 125 11/30/2008 10 125 10/20/2008 11 125 10/20/2008 12 125 10/20/2008 8 185 11/30/2008 9 185 11/30/2008 10 185 9/18/2008 11 185 9/18/2008 12 185 UMUC-KK/JP 11/20/2008 7 70 1/6/2009 10/26/2008 8 185 1/30/2009 3/19/2008 8 85 2/15/2009 UMUC-KK/JP Listed Price Date Sold Description Location Case B Case C Material Marcson’s Jewelry Inventory Listing – Rings Size Silver Oval, Pink Crystal, Wms Item Number Mfg Dawson AAK202010015 Six Petal Violet Flwr Crystal, Wms Teller Square Black Crystal, Mns AAK202000013 AA0330004551 Luson Mercy Silver/Gold Plate AAK201980012 AAK201980013 AAK201980014 AAK201980015 AAK201980016 Grey Agate, Mns FIN 615 – Macro Problem 1 Marcson Jewelry keeps their inventory based on specific identification. Everytime a ring is sold, the bookkeeper records the move from inventory to sales on an inventory worksheet. Currently he copies and pastes the items sold from one spreadsheet to another. He would like to automate the process by using a macro. To assist, you, as the Controller, have written a macro to perform the task. Follow the steps below. Create the macro and test that it works. You may use this Excel file as the starting place for your work. Feel free to edit its design or formatting as you see fit for your preferred presentation. Document (map) your workbook for the bookkeeper how to run the macro. Remember to name your saved file according to the file naming directions in the syllabus. For this example, we will assume we are reconciling March 2009 sales. 1) Type 3/12/2009 into cell I16 of the Listings worksheet and press ENTER. This entry records the date of the sale of this item. 2) Select row 16 by clicking its row number heading. This is the row we will transfer to the SALES spreadsheet. 3) Select Developer, R ecord Macro. The record Macro dialog box appears….
Attachments:
