I am working with a data set that has hundreds of columns, about 3/4 of which must be deleted. They are irregularly spaced, so I will need to go through manually one time in order to select them and delete them. I estimate it will take about 20 minutes to get through the entire file, which goes down to column RV.

Here's the problem: I have hundreds of these files. ALL of the files have identical columns (containing different data below), and the same columns need to be deleted in each data set. In other words. If AC needs to be deleted in File 1, AC will also need to be deleted in File 2. Is there a way that I can record the columns that must be deleted and then simply copy/paste those columns into a spot that will remove them?

Thank you so much for all your help over the years. You guys are super heroes, seriously.