Make a summary sheet out of 9 sheets

  • Hello there,

    I have made a large excel doc with 90 sheets with all different promotions done this year.
    All of this sheets have the same lay out and have the same summary table on their sheet.
    Now I would like to create a summary sheet in which all the different tables are summed into one.

    I was able to create a Macro which lists all my sheets into one sheet which is called overview, please see this one under:

    But this only lists the names of the sheets I have.

    Is it is possible to make a Macro which or a formula i cannot come up to which refers to all the 13 different cells in each sheet.

    Please see attached the excel file which shows what i need.

    Thanks for the help!

  • Re: Make a summary sheet out of 9 sheets

    Hi bvk1986..

    Hi and welcome to Ozgrid.

    In order to make it easier for others to read your code, please use Code Tags.

    You can do this by editing your post and highlighting your code and then pressing the # icon. This will wrap code tags around your highlighted text.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!