Question: Open macro.xlsx. Create a second workbook by your own, and name it data.xlsx. Activate the macro workbook. Record a macro while you do the following:

 Open macro.xlsx. Create a second workbook by your own, and name

Open macro.xlsx. Create a second workbook by your own, and name it data.xlsx. Activate the macro workbook. Record a macro while you do the following: Select Cell B2 on Sheet "discount'' of the macro workbook Copy the contents of this cell Activate the data workbook Select Cell A1 on first sheet of the data workbook Use Paste Special/Values to place the contents of the cell from the macro workbook into the newly selected cell Insert a new sheet into data workbook Activate the macro workbook Select Cell B3 on Sheet "discount" of the macro workbook Copy the contents of this cell Activate the data workbook Select Cell A1 on the newly inserted sheet of the data workbook Use Paste Special/Values to place the contents of the cell from the macro workbook into the newly selected cell Activate the macro workbook Stop recording. Identify all the Excel objects in your recorded Macro, for example. Workbook macro. Cell B2. etc. List them on "answer" sheet of macro workbook. Do not forget those special Excel objects. Your submission file for exercise 4 should be the macro workbook with the recorded macro, and answers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!