Question: 1 . Record a macro. Call your macro CIS 3 0 8 Exam 3 . Within your macro, do the following: a . Add a
Record a macro. Call your macro CISExam Within your macro, do the following: a Add a worksheet to the file and call it Exam b Type the first name of the President of ASU in cell A c Type the last name of the President of ASU in cell B d In cell C use a formula to find If values exist in column A and B of the row, then concatenate the last name first, a comma, a space, and the first initial of the first name into column C of the corresponding rowNOTE You must to use an IF formula with AND to find if values exist.HINT Your final formula should have IF AND, CONCATENATE and LEFT in it e Stop recording Open your macro in Visual Basic edit mode your main code area should be no more than lines at this point.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
