Hey, so I've got ~27 excel files ( I do an export each week) with data in each column. Each file has ~100k rows and ~50 columns of data. In order to be able to use the data in a more efficient way, I need to be able to extrapolate certain columns of data into a new workbook check for duplicate rows remove duplicate rows (leaving only one of the duplicates) and save that as an excel worksheet/workbook. Does anyone else use anything that might help me with this? because as it stands, I've got over 2.7million rows of data and I need about 10 columns from it (aka lots of manual labor), not to mention checking for dupes. Thx ahead.