So I have a series of workbooks that I need to make a series of (very simple) alterations to.
Foremost, I need to cycle through a series of workbooks all found in the same folder regardless of their names. In other words, it has to hit every workbook I put in a folder. While they will have a standard naming structure, I don't want to rely on it.
As its cycling through these workbooks, it should do three things. The first is "identify" the sheet I care about. That is simply defined by any sheets not named either "MTD" or "Mozart Reports." Once we're working on that sheet (it will always only be one sheet,) we have two tasks left:
1) Insert the title of the workbook into Cell A1 (always A1, so if the workbook is titled "Report 12/21/12" then Cell A1 gets overwritten with "Report 12/21/12." Is this possible?
2) I need to delete a series of several entire columns. Not just the contents, but the entire columns. In my current example, this means deleting columns: E, F, J, K, L, M, N, O, P, Q, R, S, T, U, V, X, Y, Z, AA, AB, AD.
After that, we're done
So in brief I just need to open a series of workbooks, populate cell A1 from all of them with the filename of the workbook, and delete a series of columns. The columns I need deleted in particular can be named if necessary, but if its left modular I can change it on the fly that's even better.
Please let me know if you need a sample workbook.
Bookmarks