+ Reply to Thread
Results 1 to 12 of 12

Macro To append Data from a monthly file to Master file Based on Column Headers

  1. 03-29-2016, 12:50 AM #1
    ashwankumar
    ashwankumar is offline
    Registered User
    Join Date
    03-29-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    6

    Macro To append Data from a monthly file to Master file Based on Column Headers

    Hi Guys,

    I'm New to VBA and want help from you guys.

    I'm trying to Append data from a monthly file to Master file. Can anyone plz share a code if u have any to do this.

    I want the Macro to check the Column header and then append data to the Master as sometimes in the monthly file the columns interchange.

    Thanks for Your Help.
    Last edited by ashwankumar; 03-29-2016 at 01:17 AM.
    Reply With QuoteRegister To Reply
  2. 03-29-2016, 03:44 AM #2
    kay007
    kay007 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    Please upload a sample spreadsheet with your desired output..
    Reply With QuoteRegister To Reply
  3. 03-29-2016, 07:44 AM #3
    ashwankumar
    ashwankumar is offline
    Registered User
    Join Date
    03-29-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    6

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    I have attached the Monthly file as well as the Master file

    As you can see i get data on month-wise and i want to append the data to the master month wise.

    Sometimes the columns may interchange in the monthly data.

    I would like to follow the sequence in the master and append data on a monthly basis with single click.

    Your help is much appreciated.

    Thanks...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-29-2016, 08:37 AM #4
    kay007
    kay007 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    Hi ashwankumar,

    I modified a code that i currently use in one of my reports for your use. Different part of the codes was provided by experts around here and Ozgrid.


    Pls download the data from here. I can't upload attachments hence the reason for the google drive.

    Please review the workbook and let me have your feedback!

    Here is the code behind the report:

    Please Login or Register  to view this content.
    Last edited by kay007; 03-29-2016 at 08:40 AM.
    Reply With QuoteRegister To Reply
  5. 03-29-2016, 08:38 AM #5
    kay007
    kay007 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    I assumed that the monthly report would be downloaded monthly!
    Last edited by kay007; 03-29-2016 at 08:41 AM.
    Reply With QuoteRegister To Reply
  6. 03-30-2016, 12:26 AM #6
    ashwankumar
    ashwankumar is offline
    Registered User
    Join Date
    03-29-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    6

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    Thanks Kay, this decreases my work to a good extent.

    The Macro works like a charm..

    Need some more help...

    is it possible to add a macro to drag a set formulas at the end of the data, this should happen monthly once i add the data

    and also if have multiple sheets in the master and the monthly how could i change the code in order to append from those sheets as well
    Last edited by ashwankumar; 03-30-2016 at 02:00 AM.
    Reply With QuoteRegister To Reply
  7. 03-30-2016, 03:00 AM #7
    kay007
    kay007 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    I can try and work something out for you..

    Can i see the formula that you are trying to add into the report?
    Reply With QuoteRegister To Reply
  8. 03-30-2016, 04:50 AM #8
    ashwankumar
    ashwankumar is offline
    Registered User
    Join Date
    03-29-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    6

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    Normal Formulas which concatenate two columns of the data and few more like that.
    Reply With QuoteRegister To Reply
  9. 03-30-2016, 05:32 AM #9
    kay007
    kay007 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    Ok. Please upload a sample workbook showing the formulas so that i can incorporate.
    Reply With QuoteRegister To Reply
  10. 03-30-2016, 08:35 AM #10
    ashwankumar
    ashwankumar is offline
    Registered User
    Join Date
    03-29-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    6

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    i have uploaded the files.. Thanks for your help

    i want macro which can drag those formulas

    and if i have two sheets as in the attached file macro should append the same into two different sheets in master
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 04-03-2016, 01:22 PM #11
    kay007
    kay007 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, 2010, 2016
    Posts
    102

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    Do you still require the latest modifications? I got stuck with some work last week and i wasnt able to look at the problem.

    Please let me know i should go ahead for a solution
    Reply With QuoteRegister To Reply
  12. 04-05-2016, 11:15 PM #12
    ashwankumar
    ashwankumar is offline
    Registered User
    Join Date
    03-29-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    6

    Re: Macro To append Data from a monthly file to Master file Based on Column Headers

    Yes please.. I was also stuck with some work and couldn't respond to you..
    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. [SOLVED] Saving MASTER file, automatically remove part of file name and append current date?
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-10-2014, 08:13 AM
  2. Copy cell value of all file in the folder and append to Master file
    By snsuvarna in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2013, 11:55 AM
  3. Macro to full in data from Master file to a daily recon file
    By Dnels in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-21-2013, 12:03 PM
  4. [SOLVED] Import data from excel files to append master file
    By kdawgpl9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2013, 04:32 PM
  5. [SOLVED] Macro - Master file to import data from another open file with variable file name
    By jdodz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2012, 10:56 PM
  6. Run macro on many csv files and append only one row into master excel file
    By Novice123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2012, 09:45 AM
  7. [SOLVED] Macro to copy file names and data from each file in a folder into master spreadsheet
    By dee1989 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2012, 05:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1