+ Reply to Thread
Results 1 to 4 of 4

Update columns on the master file and add new rows (based on names) on master file

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    33

    Update columns on the master file and add new rows (based on names) on master file

    Hi,

    I have a master file, which has data of two companies NOVA and Dulsco, now I would like to merge the additional data on NOVA Test and Duslco tests. The two spreadsheets NOVA test and Dulsco tests has the column testing dates update and new rows (names and other details) added. I want to combine this data of NOVA test and Duslco Test into Master - Testing. Is there a way to do this in EXCEL, I have attached the three sheets for your reference.

    Regards,
    Asif
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,072

    Re: Update columns on the master file and add new rows (based on names) on master file

    Which version of Excel are you using? Please update your user profile if this has changed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    01-09-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    33

    Re: Update columns on the master file and add new rows (based on names) on master file

    thanks, i have updated my profile. I am using 2016

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,580

    Re: Update columns on the master file and add new rows (based on names) on master file

    The information in the tutorial video linked below explains how to combine multiple .xlsx files using Get & Transform
    I hope that it will be helpful.
    https://www.youtube.com/watch?time_c...ature=emb_logo
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 0
    Last Post: 03-04-2013, 03:40 AM
  2. Consolidate Data from Multiple Files (Different File Names) into a Master File
    By dspraveen_23 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-08-2012, 12:59 PM
  3. 4folders, 4files (file names change weekly) merge into one master file, as needed
    By alkangirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2012, 08:28 PM
  4. Update master file columns with columns from slave files
    By underskinned in forum Excel General
    Replies: 1
    Last Post: 09-11-2012, 12:21 PM
  5. Seach in folder and copy data from file based on sheet names in master workbook
    By Hassų in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 09:25 AM
  6. [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
  7. One Master file to create different-2 file according to master file & save to computer
    By sonu_kumar444 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-22-2012, 06:13 AM
  8. Update cell values in master file if changes were made in update file
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2012, 03:03 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