Excel macro
Budget: $30 – $250 USD
I'm looking for a microsoft access macro that looks at a specific windows folder, finds all of the CSV or excel files in the folder. Combined, the xls or csv files have about 8 million rows and this is to consolidate the rows by removing duplicates so that there are many fewer rows. and does the following:
1) Removes unneeded columns (Columns A, H, I, K, L, M, N)
2) There will be a column with URLs (column G). You will reduce this to the core domain name. For example: it be http://www.cnn.com/pages/links/name.html and you will change this to cnn.com <-- core domain
3) Remove duplicate rows with the same core domain in column G. So if there are many rows of "cnn.com" it removes all rows aside from one.
4) If the word or text is not English in column J, then delete this row.
5) The output should be a significantly reduced number of rows so I can effectively search and filter.
Attached is an example xls file. All files will have the same column headings as in row 1.
1) Removes unneeded columns (Columns A, H, I, K, L, M, N)
2) There will be a column with URLs (column G). You will reduce this to the core domain name. For example: it be http://www.cnn.com/pages/links/name.html and you will change this to cnn.com <-- core domain
3) Remove duplicate rows with the same core domain in column G. So if there are many rows of "cnn.com" it removes all rows aside from one.
4) If the word or text is not English in column J, then delete this row.
5) The output should be a significantly reduced number of rows so I can effectively search and filter.
Attached is an example xls file. All files will have the same column headings as in row 1.