Results 1 to 3 of 3

Macro-Compare column headers across 2 Workbooks and copy the data in to the Master file

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2014
    Location
    india
    MS-Off Ver
    2007, 2010
    Posts
    2

    Macro-Compare column headers across 2 Workbooks and copy the data in to the Master file

    Hi,

    I'm new to creating Macros and want your help in resolving a problem that I've been facing.

    Aim:
    To copy values/data in columns from 'Raw' file and append it to the 'Master' file ( that is without deleting the existing data)

    I have:
    Raw file with, say, current month's data with A-H columns
    Master file with YTD (year-to-date) data. That is data since Jan with A-F columns

    I want to:
    Compare column headers of Raw file with those of Master file and copy only those column values whose header matches to that of the Master file

    The Raw file may have more columns than in Master file. Master file columns are fixed though column A:Master may not be same as column A:Raw file.

    In addition to this, the Master file has some 'calculated columns'. Is there a way to populate these columns automatically after the data is pulled from Raw file?

    I hope I'm clear with the requirement. I would really appreciate any help in this. I know a simple copy-paste and dragging formulae for 'calculated columns' would suffice, but I need this for a specific purpose.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by pamanu; 09-15-2014 at 08:44 AM. Reason: Attached the sample files for reference

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. Macro copy data from multiple workbooks to master
    By pram in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-15-2013, 03:14 PM
  3. [SOLVED] Macro copy data from multiple workbooks to master sheet
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 02-08-2013, 10:15 AM
  4. [SOLVED] Compare Col A across 2 Sheets in different Workbooks, Copy Matches to MASTER list, H/L NON
    By ali.whitaker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-09-2012, 04:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1