1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Link update from different identical files

Discussion in 'Ask an Excel Question' started by neeraj2050, Feb 12, 2018.

  1. neeraj2050

    neeraj2050 Member


    In a folder there are 12 excel files with identical columns and rows. Into another Summary file I have to get data from each of these files i.e 12 files to the Summary file in an identical manner.
    I have to manually open each file to set the link into summary file. Is there any short way to accomplish the same

    Neeraj Kumar Agarwal
  2. vletm

    vletm Well-Known Member

    Way 1)
    1) Create ONE link to any of those 12 files.
    2) Use previous link to create (and modify) other links.
    Way 2)
    Do marco which would get needed values from those 12 files.
    neeraj2050 likes this.
  3. Marc L

    Marc L Excel Ninja

    Hi !
    No directly under Excel …

    But you can activate Macro recorder before operating manually :
    you will get your own free code base !

    For any question about a code, see in appropriate VBA section
    as here it's the Excel section (formulas, inner features, …).
    neeraj2050 likes this.
  4. Chihiro

    Chihiro Excel Ninja

    Use PowerQuery if you have access to it. Or use MS Query if not.

    Especially when using PowerQuery, you can merge/append all files in a folder into single table and will update itself when refreshed with either new files added or changes to existing files (provided structure remains consistent).

    MS Query requires bit more maintenance, and initial set up requires some knowledge of SQL query statements.

Share This Page