I have a worksheet with dozens of fiscal weeks aligned either side by side and one under the other, leaving one or two row(s) and column(s). You can see it in the attachment file. They are aligned as if they are tables but they are not. I applied some SUMIFS and COUNTIFS to get values from another sheet in the same workbook.
Now, here is the problem: I need to add another team or value to those tables. Is there any way to do this? Is it possible to apply something like "named range tables". When I added another team name, this should have been also updated in another "tables".
This solution would really be great and helpful for me and probably any other people on this forum.
Thank you in advance.