Results 1 to 12 of 12

Copying Specific Data from One Workbook and Pasting to Another

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Copying Specific Data from One Workbook and Pasting to Another

    I am very new to this but I am trying to create a Macro that will copy specific data from multiple workbooks into a single "Master File" workbook.

    To be more specific, I have created a workbook with multiple sheets but one of the sheets tracks specific items in a given facitlity. I have 12 different people conducting the surveys and populating the sheet and saving it with their "zone number" in the file name. I want a macro that would run and copy the zone specific data from these other files and past it into my "Master File".

    I have been trying to understand and modify some things from other threads but have been unsuccessful. I have attached a very simplified version of my workbooks. Book1 would be for zone 1, Book2 for zone 2, etc. I would like to take that data for each zone from the respective workbook and get it copied and pasted into the BookMaster.

    I hope that makes sense and would appreciate any insight you can offer.
    Attached Files Attached Files

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