Finish Scraper 2

Current LinkedIn_Scraper scrapes employee info from [login to view URL] and outputs in file. Source code and scraper attached. To run scraper, run as administrator then: 1. In website box put: [login to view URL] 2. In Folder box select your output folder destination 3. In ID put: 1st Constitution Bank 4. Click "Scrap" A csv file is put in your output folder when scrape completed Next stage needed: 1 Job Titles Find matches in column "designation" of output file with column A of file [login to view URL] attached. If match found, put text in Column B of [login to view URL] into col H of output file If 2 matches found, put 2nd match in col I of output file If 3 matches found, put 3rd match in col J of output file If 4 matches found, put 4th match in col K of output file If no match found put text "Officer" in col H of output file 2 Departents for Search All Find matches in column "designation" of output file with column A of file [login to view URL] attached. If match found, put text in Column C of Columns [login to view URL] into col L of output file If 2 matches found, put 2nd match in col M of output file If 3 matches found, put 3rd match in col N of output file If 4 matches found, put 4th match in col O of output file If no match found leave empty 3 Departments Find matches in column "designation" of output file with column A of file [login to view URL] attached. If match found, put text in Column C of Columns [login to view URL] into col P of output file If 2 matches found, put 2nd match in col Q of output file If 3 matches found, put 3rd match in col R of output file If 4 matches found, put 4th match in col S of output file If no match found leave empty Exception: If match found with designation and column A of [login to view URL] AND match found with designation and column A of [login to view URL] then ignore match 4 Sector Find matches in column "designation" of output file with column A of file [login to view URL] attached. If match found, put text in Column B of Columns [login to view URL] into col T of output file If 2 matches found, put 2nd match in col U of output file If 3 matches found, put 3rd match in col V of output file If 4 matches found, put 4th match in col W of output file If 5 matches found, put 5th match in col X of output file If 6 matches found, put 6th match in col Y of output file If 7 matches found, put 7th match in col Z of output file If 8 matches found, put 8th match in col AA of output file If 9 matches found, put 9th match in col AB of output file If 10 matches found, put 10th match in col AC of output file If no match found leave empty 5 Job Title Grouping In column AD of output file put text found in columns H, I , J, K separated by "/" eg: text/text/text/text If any of columns I, J, K are empty do not include and do not display the "/" If column I matches column H do not display If column J matches column H or I do not display If column K matches column H, I or J do not display If col I matches col A in [login to view URL] and any of col J, K or L matches col B in [login to view URL] then display col B from [login to view URL] in col T of output file 6 Department Grouping In column AE of output file put text found in columns P, Q, R, S separated by "/" eg: text/text/text/text If any of columns L, M, N, O are empty do not include and do not display the "/" If column M matches column L do not display If column N matches column L or M do not display If column O matches column L, M or N do not display 7 Search All Grouping In column AF of output file put text found in columns L, M, N, O, T, U, V, W, X, Y, Z, AA, AB, AC, AD, AE separated by "/" eg: text/text/text/text If any of columns T, U, V, W, X, Y, Z, AA, AB, AC, AD, AE are empty do not include and do not display the "/"