I have a pivot table with multiple brands listed in alphabetical order. Based off that pivot table I want to create a new table ("new table" worksheet) that lists only those brands that I consider "buyable" first, followed by the remaining brands listed in the original pivot table. Because the data input range for the pivot table can change over time, simply referencing cells would cause an error in where those brands deemed "buyable" would appear in the "new table".
Basically, for visual purposes (and table/reference purposes later on) I want to list only those brands that are buyable first, followed by all the other brands in the pivot table.
I have tried {if(D6:J6='Brands to Buy'!C5:I5,'Pivot table'!D7,'Pivot table'!E7)} but it still lists those brands which I listed first as buyable. Surely there is a way to automate this so that a change inthe pivot data will not affect the order in which my buyable brands appear. I have attached a sample workbook so you all canget a clear image of what I want to do. Any help is greatly appreciated as I have been stuck on this for a week now.
Thanks in advance!
Bookmarks