Hi,

I have a set of 48 separate workbooks, each with several columns and hundreds of rows. In each of these workbooks, I want to insert a column in Column A, and in each row under the new Column A, I want to copy the name of the file. So for example, if the file is called "Sample," I want Column A to look like this:

Sample
Sample
Sample
Sample

for each row that has data in all 48 workbooks. Obviously the workbooks all have different names.

Is there a macro that could do this? Or any other way to do it?

Thanks,

George