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:
Code
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
Display More
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!