Скачать или смотреть How to Convert Fragmented Data to a Table In Excel Using VBA

This video walks you through a simple example of converting a fragmented Excel report into a data table that can be used for charts, pivot tables, etc. If you've ever exported a report to Excel from an ERP system, use Crystal Reports, or have every converted a PDF to Excel, you've probably dealt with this problem. Once you teach yourself how to spot the unique characteristics within reports, you can start converting these reports in 5 minutes. This can save you hours of copying and pasting to extract the data you need!

00:00 Intro
00:13 Create module
01:08 Extract raw data to memory
02:10 Create a blank grid in memory
03:18 Record column numbers to be extracted
05:02 Read the raw data line by line and extract needed fields
11:33 Paste report table to new sheet
13:58 Run the macro
14:32 Conclusion