The Link to .xlxs file to use is below. Answer file can be kindly shared via a l

Question

The Link to .xlxs file to use is below. Answer file can be kindly shared via a link like google share drivw with steps used.

Record a macro that helps you to prepare inventory reports. Use HWl_l.xlsx on Blackboard in Assignment 1. Select tab "day l" to record the macro. Name it "InventoryReport" and you do not need to specify the shortcut. Record the following steps: Select cells A1: B2 (2x2 cells), Merge & Center the selected cells Type in the merged cell "Inventory Report" Type "IDS 331" in cell B4 Type your name in cell B5 Enter formula "=Today()" in cell B6 Format cell B6 as Date, in the type of "mmmm dd, yyyy", for example. "March 14, 2012" Select cell Al, increase the font size to 16, make it Bold, and change it to any color you'd like to Select cells B4: B6, and make the font Bold Enter formula to calculate Ending Inventory in cell B12 Stop recording, save your file. Be careful about your file type. Test your recorded macro on tab "test". The resulted worksheet should be the same as you did in "dayl". Go to VBE, highlight your recorded macro and copy the code: Insert new module by right click on Modulel and choose Insert Module, paste code in the new module. Change the second Sub name into "InventoryReportChangeDate". Modify this new Sub so that the date in cell B6 is the day after today. E.g., if today is 09/01/2017. you should show 09/02/2017 in B6. Save and test your macro "InventoryReportChangeDate" on tab "day2". Your submission file for exercise 1 should contain 2 macros.

Explanation / Answer

https://1drv.ms/x/s!AkI6DfDpRp3mhjL8aw0IX5yZ50xs

please find the link to result excel sheet.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.