Hi
I have tried googling and I havent been able to find anything useful so hoping someone can help. I have attached a subset of the data but to give you an idea the actual file has approx. 46 categories across columns and 280 tiers along rows. In my subset, I have shown 3 columns 'cat 1, 2, 3' and 6 tiers.
I receive the data monthly in the same format and ideally what I want to create is a summary tab that uses sumif to sum all the data for relevant categories only to create a rolling monthly view by automatically knowing the correct monthly worksheet. Exactly like the attached but not using indirect because with the amount of data, it takes too long to calculate.
Alternatives please, vba welcome
cheers,
Dipi
Bookmarks