Results 1 to 2 of 2

Thread: copying data from multiple workbooks into another

  1. #1
    Junior Member
    Join Date
    Aug 2012
    Posts
    1
    Rep Power
    0

    copying data from multiple workbooks into another

    Hi,

    I am a novice in writing macros.
    I need to copy data from only the first sheet of multiple workbooks whose path are given in the look up sheet of destination workbook.
    The macro should run in a way that it opens each file from the paths provided in subsequent rows, autofilter the date columns based on lastweek, thisweek and nextweek, and copy the range B6:N999 from each sheet and paste it in the first sheet of activeworkbook(destination workbook).

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    So you are saying you have a lookup sheet in a destination workbook, and for each file path given in the lookup sheet (probably in a single column), these workbooks need to be opened, the data in the first sheet be filtered for last, current and next week, and then copy the filtered data in B6:N999 and paste it in some destination sheet of the destination workbook.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 2
    Last Post: 05-28-2013, 05:32 PM
  2. Import Data From Multiple Workbooks To Another
    By Jorrg1 in forum Excel Help
    Replies: 2
    Last Post: 05-13-2013, 05:00 PM
  3. Replies: 1
    Last Post: 05-09-2013, 08:56 AM
  4. Replies: 2
    Last Post: 11-08-2012, 01:15 PM
  5. split data into multiple workbooks with 3 conditions.
    By malaionfun in forum Excel Help
    Replies: 5
    Last Post: 05-11-2012, 11:26 AM

Posting Permissions

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