+ Reply to Thread
Results 1 to 3 of 3

Copy/Paste data from master workbook to multiple spreadsheet

  1. 07-17-2013, 03:27 PM #1
    lilbamboo
    lilbamboo is offline
    Registered User
    Join Date
    05-03-2013
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    24

    Exclamation Copy/Paste data from master workbook to multiple spreadsheet

    Hello,
    I'm looking for some help with macro for this urgent task that need to be done by tomorrow. Basically, I have a Master workbook with actual data that need to copy over to the invidual speadsheet(1000,1110,1111, etc). I need to copy colum G7:I94 from the Master and paste it on the individual workbook with same column and row. I tried to record a macro and look at other blog in the forum but couldn't find a solution that works. Since i'm running out of time, hoping someone can help me out. Much appreciate!!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-17-2013, 03:48 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copy/Paste data from master workbook to multiple spreadsheet

    I found this link on jerrybeaucaires site.


    https://sites.google.com/a/madrocket.../sheet1-to-wbs
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 07-17-2013, 04:05 PM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copy/Paste data from master workbook to multiple spreadsheet

    I found this link ont rondebruin site.

    Create a workbook from every worksheet in your workbook

    http://www.rondebruin.nl/win/s3/win007.htm
    Reply With QuoteRegister To Reply
  4. 07-17-2013, 06:52 PM #4
    lilbamboo
    lilbamboo is offline
    Registered User
    Join Date
    05-03-2013
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Copy/Paste data from master workbook to multiple spreadsheet

    thanks for the quick response. I will look into it and let you know how it goes.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy paste data from a Master file to Multiple Reports
    By spiwere in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-21-2013, 01:22 PM
  2. Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets
    By NumberCruncher311 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2013, 08:21 PM
  3. Copy Data from multiple workbooks to a master Workbook
    By zeeez in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-04-2012, 01:45 PM
  4. [SOLVED] Stock market data find symbol from csv data file, copy and paste to Master workbook
    By wkurukul in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2012, 10:14 AM
  5. copy paste from multiple workbooks to master workbook
    By ravinder_tigh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2009, 02:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1