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:
Sub ListWorkSheetNamesNewWs() Dim xWs As Worksheet On Error Resume Next Application.DisplayAlerts = False xTitleId = "Overview" Application.Sheets(xTitleId).Delete Application.Sheets.Add Application.Sheets(1) Set xWs = Application.ActiveSheet xWs.Name = xTitleId For i = 2 To Application.Sheets.Count xWs.Range("A" & (i - 1)) = Application.Sheets(i).Name Next Application.DisplayAlerts = True End Sub
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!