A report from a 3rd party vendor can only be exported to Microsoft Word is very pretty and in a table-like format. However, each individual data point was contained in what appeared to be a textbox. Therefore, when attempting to copy paste the results into excel, all headers, footers, and data points are in their own cell, but in the same column.
Example of pasting report in cell A1:
- Option Explicit - always use this to ensure all variables are declared
- Screen Updating - I use this to keep the screen from flashing when switching sheets and to make the macro run faster
- Do until Loop - This is used to step down the worksheet row-by-row until a certain condition is met
- Select Case - This is like a big IF/Then statement.