Inserting new column across multiple spreadsheets and filling them

[rsmith10]

Hi everyone,
So I have been tasked with inserting a new column across multiple (around 300 ) spreadsheets and filling that column with data. I have minimal experience with excel and programming but doing this manually would be a nightmare. Is there a way to make excel automatically do this?

The spreadsheets have a varying number of rows, but the column will always need to be inserted at E. Also, E1 should be filled with "New Name" and every row below that with the formula: "=SUBSTITUTE(D2,MID(D2,LEN(D2)-9,6),"20"&RIGHT(MID(D2,LEN(D2)-9,6),2)&LEFT(MID(D2,LEN(D2)-9,6),2)&MID(MID(D2,LEN(D2)-9,6),3,2))"

Let me know if there's any questions. Any help y'all could give me would be greatly appreciated. Thanks in advance!

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.