+ Reply to Thread
Results 1 to 2 of 2

Merge Data from specific columns of multiple workbooks/sheets into an Existing Master file

  1. #1
    Registered User
    Join Date
    05-16-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Merge Data from specific columns of multiple workbooks/sheets into an Existing Master file

    Hi,
    I have an existing Master workbook which is being used by numerous people to obtain updates. The updater filters by their territory, makes their updates and then save the workbook with a different name (adding their initials to the file name). The new workbook is then returned to me for updating on the Master workbook. There are currently 35k+ rows and columns A-W. I don't want to copy and paste all the updates into the original workbook. The columns that need to be updated are V-W. I am looking for a formula or macro that can be run to copy the information in these 2 columns on the individual workbooks/worksheets to the master workbook/worksheet. I have looked at several posts on this site, but I didn't see any that worked for this application. Any help you can give is much appreciated.

  2. #2
    Registered User
    Join Date
    05-16-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Merge Data from specific columns of multiple workbooks/sheets into an Existing Master

    Sorry, forgot to mention that I am using Excel 2007, but the master sheet is an .xls file and some of the updated files are .xlsx and some are .xls.
    Columns V-W should only be copied/pasted to the master if Columns M and P match on the master and the update file.
    Last edited by VWard; 10-24-2013 at 06:32 PM. Reason: add attachments

+ 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. Export/ Retrieve specific data from multiple workbooks and Import into Master workbook
    By SerenitynWisdom in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-29-2013, 10:41 PM
  2. Pulling Data From Multiple Workbooks/Multiple Sheets into one Master Book
    By LSUARefugee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2013, 12:37 PM
  3. I need to copy data from various workbooks into one master file, specific data
    By madhumith13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2013, 09:14 AM
  4. Data Extraction Multiple Workbooks And Sheets To Master Spreadsheet
    By shido in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2013, 09:11 PM
  5. Add data columns and merge specific data sheets into master sheet
    By sshahils in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2011, 10:50 AM

Tags for this Thread

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