+ Reply to Thread
Results 1 to 3 of 3

copying data from excel files in a source folder to target folder

  1. #1
    Registered User
    Join Date
    02-18-2013
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    3

    copying data from excel files in a source folder to target folder

    Hi

    I would require a macro to copy multiple files in a source folder to a new target folder.

    the source files are in a existing format, while copying the data should be moved to a new standard format.

    i would need to move all the files from one format to new format in one go.

    sample files are given in this post.

    like User firstname in source file is in cell B1, where as in new format it is in D1
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-26-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: copying data from excel files in a source folder to target folder

    Hi

    Please Login or Register  to view this content.

    Regards
    Piyush

  3. #3
    Registered User
    Join Date
    02-18-2013
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: copying data from excel files in a source folder to target folder

    Thanks piyush, this code i have modified as per my requirement and it is working fine. i have to handle some format things while copying from source to target file

    when i am copying from source and if the cell is not having a value, the target cell format is getting changed like background color is changing

    Also if am copying data from source file based on some cell data like i have Details in cell A15 followed by couple of rows with data followed by blank line and then product in A18

    the lines followed by details may vary file to file , can you help in handling these format things

    thanks again

+ 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