+ Reply to Thread
Results 1 to 3 of 3

Open closed workbook, copy ranges from multiple sheets into an active Mastersheet

  1. #1
    Registered User
    Join Date
    07-08-2010
    Location
    atlanta
    MS-Off Ver
    Excel 2003
    Posts
    26

    Open closed workbook, copy ranges from multiple sheets into an active Mastersheet

    Trying to open a file located in C > vba > sources

    Then copy range A4 thru last row with data from three sheets called;"sourceA" and "sourceB" "SourceC"

    Into the active workbook called: Destination ; specific sheet called:master starting at A10 (copy "sourceA" first, then SourceB right below, then sourceC below sourceB)

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Open closed workbook, copy ranges from multiple sheets into an active Mastersheet

    That is a very common request.
    You searched this board and came up empty handed?
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    07-08-2010
    Location
    atlanta
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Open closed workbook, copy ranges from multiple sheets into an active Mastersheet

    Can't disagree, I found a reasonable code already.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to import all sheets from closed workbook to Active Sheet.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2014, 02:42 PM
  2. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  3. Copy same range from multiple sheets and paste into one sheet of active workbook
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2013, 01:41 PM
  4. Run Macro in closed workbook and copy specific coloumn in active workbook
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2013, 03:43 AM
  5. Macro to open a closed workbook and select copy cells into an open workbook
    By helloganesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 02:00 PM
  6. Copy 2 sheets from a open workbook and paste to a closed workbook
    By grimston in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2012, 03:27 PM
  7. Copy worksheet from closed workbook into active/existing workbook.
    By rasikvekaria in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2012, 06:55 AM

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