Join Dennis Taylor for an in-depth discussion in this video Watching VBA code being created, part of Excel for Mac 2016: Macros.
- [Instructor] In this work book called RealtorList,…a file without macros, we've got some data…in columns A and B.…It's well over 1000 rows and this is from one state.…We will be getting data from other states as well.…And the problem is that we can't do a whole lot…with the data in its current form.…What we really want to see here, for example,…would be in column D, how about all the names?…In column E, how about all the companies?…In column F, how about the office phones?…As you can see, there are three items of information…about each person here.…Person's name, company and office phone number.…
And there are a couple of approaches to consider…how we would manipulate this data.…Now one approach, it might be lengthier,…would involve possibly copying data and transposing it?…Imagine seeing the person's name here, company here,…office phone, doing that for each person.…You know that would take a long time if done manually.…We could turn on the macro recording process…and do this for three or four cells,…take a look at the code and possibly we could use…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with existing macros
- Creating macros with the recording process
- Viewing and modifying VBA code
- Running a macro from the Developer or View tabs
- Running a macro from a keystroke shortcut
- Running a macro from an object or picture
- Creating and updating the Personal macro workbook
- Recording a formatting macro
- Expanding a macro with an IF statement
- Creating interactive macros
- Stepping through macros