+ Reply to Thread
Results 1 to 4 of 4

Move data from master workbook to multiple workbooks.

  1. #1
    Forum Contributor visha_1984's Avatar
    Join Date
    11-27-2012
    Location
    Pune,India
    MS-Off Ver
    Excel 2010
    Posts
    290

    Move data from master workbook to multiple workbooks.

    hello everyone

    I m trying to move data from master workbook to multiple workbooks.
    1) I have folder with name of dates.
    2) Move data from master workbook to datewise folder.
    3) Folder name is in F col and workbooks name in E col.
    4)Macro should filter in E col and copy row and paste into folder according to parties name.

    Any one plsss help
    Attached Files Attached Files
    Last edited by JBeaucaire; 02-22-2013 at 05:26 AM.
    Happy to Help

    VISHA

    Click *, if the suggestion helps you!
    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>> "Mark your thread as Solved"

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Move data from master workbook to multiple workbooks.

    Is your folder having the name like 21-Feb-2013 or is it in some other date format? This is important from the code perspective.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor visha_1984's Avatar
    Join Date
    11-27-2012
    Location
    Pune,India
    MS-Off Ver
    Excel 2010
    Posts
    290

    Re: Move data from master workbook to multiple workbooks.

    yes the date format is same .

    Thanks Arlu for giving ur precious time.

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Move data from master workbook to multiple workbooks.

    Will the workbooks already exist in the folders? Should there be a check to see if they do exist?

    If they do, should the macro append the data or delete the files and restart?

+ 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