+ Reply to Thread
Results 1 to 2 of 2

VBA to update data from one Excel file to another

  1. #1
    Registered User
    Join Date
    10-07-2017
    Location
    Malta
    MS-Off Ver
    2010
    Posts
    1

    VBA to update data from one Excel file to another

    I have a master excel file (ABC.xls) which has n number of rows and columns.

    And also i have another excel file (DEF.xls) which has limited number of same data from the master excel file (ABC.xls).

    I need a macro code for if i update some values in the master excel file (ABC.xls), automatically
    the values needs to update in the second excel file (DEF.xls).

    Can you please any one help on this?

    Thank you in advance :-)

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: VBA to update data from one Excel file to another

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Excel file with macro to update data & generate reports
    By Burt_100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2014, 12:51 PM
  2. Excel data auto update from .dbf file
    By avk in forum Excel General
    Replies: 1
    Last Post: 12-14-2012, 03:10 AM
  3. Update chart souce data - excel file was uploaded
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-01-2010, 05:01 PM
  4. update masterfile with data from everyday new excel file with date stamp in name
    By Sameem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2010, 12:42 PM
  5. [SOLVED] update data from one excel to another excel file
    By venu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2006, 05:25 PM
  6. [SOLVED] Update Value Message, Getting Data from Other Excel File
    By pcook911 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2005, 07:05 PM

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