Excel VB Instr, For Loop, Arrays and Transpose

This video shows an example of how to use Visual Basic to manipulate strings of data in Excel. We build a subroutine to get values from a report. I have a separate video that shows how to accomplish this using Excel Functions.