Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jul 18, 2016
Download Files: https://people.highline.edu/mgirvin/A... In this video use Macro Recorder to record six Macros: 1. (00:12) Basics for Recorded Macros (VBA) 2. (05:55) Absolute Reference Macro: Format report that always has the same number of columns and rows. This Macro is stored in Personal Workbook. 3. (18:32) Absolute & Relative Reference Macro: Format report that that has an unknown number of rows 4. (26:38) Relative Reference Macro to convert vertical records into a proper data set with horizontal records 5. (31:09) Search for VBA Code online: Function to spell out numbers as words 6. (33:04) Search for VBA Code online: Add or count cells with red fill 7. (35:52) Form Control Button to Add Record to Existing Proper Data Set on different sheet. 8. (39:37) Summary