Results 1 to 4 of 4

Copy specific range from several workbooks with 2 sheets each located in same folder

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2011
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copy specific range from several workbooks with 2 sheets each located in same folder

    First: I'm a newbie in vb.
    I've been trying to combine different codes in the forum to get what I want but with no luck.
    Every day I get 4-5 excel-files in a folder, the workbooks has different names every day. From each workbook I want to copy range A6:C50 from every sheet. Each workbook contains 2 sheets with various names.
    I want to paste it in the open workbook in the first empty row. This workbook should also contain the macro.
    The problem is that I want everything I copy from the first sheet in every workbook to be pasted into columns A:C, and from the second sheet into columns F:H. The data from the second sheet could also be pasted into another sheet. I can manage this later with another code.
    I prefer to do this with the workbooks closed. (the workbooks I copy from)

    It's not always there is data in every row, so if it's possible to only copy the rows that contains a value in column A, it would be great.
    Greatful for all the help I can get since I'm not very good with vb.
    /rog
    Last edited by Rog; 02-06-2011 at 05:34 AM.

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