+ Reply to Thread
Results 1 to 2 of 2

How to insert "column A" into multiple workbooks automatically

  1. #1
    Registered User
    Join Date
    06-24-2009
    Location
    toronto
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to insert "column A" into multiple workbooks automatically

    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

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: How to insert "column A" into multiple workbooks automatically

    Try this. Copy the 48 workbooks into a test folder, keeping the originals for safe keeping, in case this macro messes them up.

    Put this code in a new workbook and save it in another folder, away from the 48 workbooks. Modify the code to change folder string containing the workbooks as required and run the macro.
    Please Login or Register  to view this content.

+ 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