Open macro.xlsx. Create a second workbook by your own, and name it data.xlsx. Ac
ID: 3885185 • Letter: O
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: 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.Explanation / Answer
//to record macro goto view tab and select Macro -> Record Macro
Follow the instructions
This is macro which has been recorded after the given steps
Sub myMacro()
'
' myMacro Macro
'
' Keyboard Shortcut: Ctrl+Shift+Y
'
Selection.Copy
Application.WindowState = xlNormal
Windows("data.xlsm").Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets.Add After:=ActiveSheet
Windows("macro.xlsm").Activate
Range("B3").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "content2"
Range("B3").Select
Selection.Copy
Windows("data.xlsm").Activate
ActiveSheet.Paste
Windows("macro.xlsm").Activate
End Sub
//In this myMacro is the macro name and data.xlsm and macro.xlsm are two workbooks. and keypboard shortcukey to enable macro is Ctrl + shift+Y for this specific macro.
//I am attaching the macro enabled excel workbook links
Which may help you
https://1drv.ms/x/s!AnTSkDPRZYm0gdhPUc7AgbypKKyj2A
https://1drv.ms/x/s!AnTSkDPRZYm0gdhRlISkBd98kRhKEQ
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.