1
00:00:00,00 --> 00:00:02,000
Open the module file and start in the input 
worksheet.

2
00:00:02,100 --> 00:00:09,000
In the upper left corner, enter the directory 
location(file path)

3
00:00:09,300 --> 00:00:16,900
Enter the name of the file to be imported 
under Excel file name.

4
00:00:17,000 --> 00:00:22,600
Remember to specify the file extension, typically 
.xls or .xlsx

5
00:00:22,700 --> 00:00:34,900
Under Output, type the file name of the final 
template.

6
00:00:35,000 --> 00:00:37,900
Go to Add-Ins in the ribbon

7
00:00:38,000 --> 00:00:40,900
Click pvtscannerIHA.

8
00:00:41,000 --> 00:00:46,600
Click 'Scanning PVT Report'

9
00:00:46,700 --> 00:01:07,200
Wait, while programme is working...

10
00:01:08,200 --> 00:01:11,000
Click OK to the messages appearing

11
00:01:11,100 --> 00:01:15,900
All the tables are now imported to the workspace

12
00:01:16,000 --> 00:01:20,200
The table headers ae categorized according 
to keywords

13
00:01:20,300 --> 00:01:30,000
In the 'output' sheet you will find the complete 
tables