+ Reply to Thread
Results 1 to 2 of 2

Inserting Columns into many excel files

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    New York
    MS-Off Ver
    2010
    Posts
    1

    Inserting Columns into many excel files

    Hello all,
    First I wanted to introduce myself. My name is Paul and I am new to Excel programming but have been working in excel for many years using different techniques. I look forward to learning from you all and hopefully I can contribute as well.

    I have approximately 400 excel files that were created using the same "Form". The "form" is just an excel file that has been setup for manual data entry. The company I work for is controlling all of our documentation and making sure that everyone is using the correct (controlled) forms. I need to update the "Form" and all of the 400 files so that they all have some additional columns. Specifically, I would like to insert 3 columns in each of the files (at the same location for all files), one to add room for a Document Revision and the other two for additional comments.

    Can someone here please explain to me how I would create the programming to accomplish this? Any help/direction you can give is appreciated. Also I apologize in advance if I ask a stupid question to any of your responses.

    Thanks,
    Paul
    Last edited by eqd053; 02-07-2013 at 05:27 PM.

  2. #2
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Inserting Columns into many excel files

    Maybe this.
    Many thanks to all who have helped me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1