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.

    Yours,
    Chandoo
  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

    Hui...

  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

    Messages:
    194
    Greetings!!

    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

    Regards
    Neeraj Kumar Agarwal
  2. vletm

    vletm Excel Ninja

    Messages:
    3,521
    neeraj2050
    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

    Messages:
    3,820
    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

    Messages:
    4,570
    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.
  5. neeraj2050

    neeraj2050 Member

    Messages:
    194
    Sir, I do not posses any idea about PowerQuery /MS Query

    Could I be guided

    Regards
    Neeraj Kumar Agarwal
  6. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,570
    Can you give more details on what exactly you are trying to accomplish?
  7. neeraj2050

    neeraj2050 Member

    Messages:
    194
    I have 12 excel files and all the 12 files will be updated through one source file i.e File"A".

    Manually I have to open each file and update with source file. All I want to update all the 12 files with File"A" without open these 12 files
  8. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,570
    Upload sample workbooks. Source and destination(s). As well as clearly indicate what information needs to be pushed where.
  9. neeraj2050

    neeraj2050 Member

    Messages:
    194
    Sir, my request which have been discarded considering duplicate is not at all duplicate. Request you to please revisit the same

Share This Page