Excel VBA Macro for parsing rows of text

Develop an Excel VBA Macro and deliver in a .xlsm Excel file. The macro will meet the following requirements: 1 Develop a well-documented Excel VBA macro that will loop through a highlighted range selection in the Input worksheet, column by column, then row by row. 2 When the macro is run it will create a new worksheet named 'Output' that has the same number of rows as the Input worksheet. 3 The macro will loop through the current selected range of cells in the Input worksheet looking for two keywords, 'FROM' and 'INTO'. These keywords may occur 0, 1 or >1 in a row. 4 The Input worksheet can contain a maximum of 256 columns and 1000 rows. 5 Each row in the Output worksheet should contain all of the same columns as the original Input worksheet (even those NOT selected). In addition, it will contain only the first cell immediately to the right of each occurance of the keywords. 6 If it finds either FROM or INTO, it will move to the right by one cell and copy that value (TRIGGER REFERS TO) in the next empty column in that row. 7 The macro will have the effect of collapsing all of the columns following the keywords 'FROM' and 'INTO' but preserving the cell immediately to the right of the keyword. 8 The result will look like the Output worksheet. Column headings are NOT required. 9 Input text may be either upper case, lower case or mixed case. Output should be ALL UPPER CASE. 10 VBA code must be well documented with comments and be self-contained; it cannot branch out or call any proprietary subroutines or any code not included in the delivered Excel XLSM. 11 Freelancer Employer reserves the right to use, modify or enhance the VBA macro code in any manner. 12 The Freelance Developer who developes this Excel VBA macro relinquishes all rights to the legal ownership or authorship or use of the VBA macro code.