+ Reply to Thread
Results 1 to 6 of 6

Copying from multiple workbooks

  1. #1
    Registered User
    Join Date
    04-11-2007
    Posts
    12

    Copying from multiple workbooks

    I've been trying like crazy to get this to work. I'm trying to take all the data from column A in multiple workbooks and list them one after another in column A of my transfer workbook. The trouble really comes from from needing to do it with a random amount of workbooks and lengths of column A
    This is what I have so far:
    Please Login or Register  to view this content.
    Any help would be great.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-11-2007
    Posts
    12
    oops. I did change the name of transfer.xls to zip it and post. I had to delete a bunch of info due to work security. The orginal is titled correctly.

  3. #3
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Rlyeh462
    oops. I did change the name of transfer.xls to zip it and post. I had to delete a bunch of info due to work security. The orginal is titled correctly.
    Hi,

    instead of
    Please Login or Register  to view this content.
    try
    Please Login or Register  to view this content.
    hth
    ---
    Si fractum non sit, noli id reficere.

  4. #4
    Registered User
    Join Date
    04-11-2007
    Posts
    12
    Thank you very much. It works perfectly now.

  5. #5
    Registered User
    Join Date
    04-11-2007
    Posts
    12
    One more quick part on this. I need to put the file name in column k but I can't get it to loop right. Each row needs the name in "K" from the file it came from and all I can get it to do is put it in the top most unused row.

  6. #6
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Rlyeh462
    One more quick part on this. I need to put the file name in column k but I can't get it to loop right. Each row needs the name in "K" from the file it came from and all I can get it to do is put it in the top most unused row.
    Hi,

    if
    Please Login or Register  to view this content.
    was where you wrote the line, then
    Please Login or Register  to view this content.
    should put your saved filename into K

    hth
    ---

+ 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