Question: Create a macro for this workbook named Add _ Leg with the description Add a leg to the driving itinerary. Begin your macro on the

Create a macro for this workbook named Add_Leg with the description Add a leg to the driving itinerary. Begin your macro on the Driving Form sheet. Macros record every keystroke so be sure these directions are accessible without clicking away from Excel during the macro recording. The macro, set up with Ctrl + G (upper case G) as your shortcut, should perform the following tasks:
a. Go to the Driving Itinerary worksheet to give the sheet the focus.
b. Go to the travel_end cell using the named range
c. Insert a new sheet row directly above the travel_end cell on the Driving Itinerary worksheet. Hint: Insert the row in such a way that only one cell is active after the insert row is complete. Do not insert the row by selecting the row number to select the entire row.
d. Go to the Driving Form worksheet and copy the values in the range C6:F6 to the clipboard.
Create a macro for this workbook named Add _ Leg

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 Programming Questions!