+ Reply to Thread
Results 1 to 2 of 2

Need macro help to copy from specify source file,sheet,range to specified destination file

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need macro help to copy from specify source file,sheet,range to specified destination file

    I have files in Source and destination folders, I have to perform below in my macro.
    Source Destination
    Copy from File Copy from Sheet Range to copy Paste to file Paste to sheet Range to Paste
    C:\Source.xlsx Sheet1 A1 C:\Destination.xlsx Sheet1 A1
    C:\Source1.xlsx Sheet2 A2 C:\Destination1.xlsx Sheet2 A2
    C:\Source2.xlsx Sheet3 A3 C:\Destination2.xlsx Sheet3 A3
    C:\Source3.xlsx Sheet1 A4 C:\Destination3.xlsx Sheet2 A4
    C:\Source4.xlsx Sheet1 A5 C:\Destination4.xlsx Sheet1 A5

    Please remember, files may increase or decrease and also sheet and range may change each time, but I'm specifying it in my macro template.
    Let me know if I need to provide any other details.

    Thanks,
    Raghuram

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,956

    Re: Need macro help to copy from specify source file,sheet,range to specified destination

    If you table is as shown in columns A to F, with headers in row 1 and values starting in Row 2:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Copy, edit and save workbook to same location as source data file, not macro file.
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2014, 09:01 AM
  2. macro to copy used range and paste in the body tag of a html file/text file
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 08:34 PM
  3. Macro to copy and paste source file to destination file using cell value
    By mani88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2013, 10:16 AM
  4. Macro to copy range from temp file to open file
    By 4luk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 02:22 AM
  5. How to update destination file with source files closed?
    By Alex Costache in forum Excel General
    Replies: 2
    Last Post: 08-01-2006, 05:10 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