tigger - 6/18/2019 23:32 ... but the master sheet has to be of a set size. I just make it bigger than I will ever possibly need to begin with, so there is plenty of extra room to add new entries.... That's why I use the tables feature that has been part of Excel for the past 10 years. Makes issues with incomplete ranges completely in the past. Life is so much easier now. The original request was the see the actual data on the other sheets, but sorted differently. The only way to do that is through the pivot table feature. So summary formulas are only part of what he is looking for. And I would recommend SUMIFS (and COUNTIFS) which is a better version of the very limited SUMIF There is another way, actually. That's to have the master data on a sheet in a completely different file. Then have a query set up to pull it into a second file with different arrangements on different sheets. It's something I've done quite often, but not for this exact reason. |