I need to select and delete a few columns from a range but at intervals. For example: If my range starts from Column F, then I'd like to select 7 columns, leaving Column L, and then redoing this same pattern in a loop for the rest of the columns, and then deleting those selected columns. The columns that I want to retain have calculated fields in them. So I want to delete the rest of the columns that I've no need for. But doing this manually for a large number of columns will be difficult as I'd have to do this again the next time any other data is uploaded.
Bookmarks