I'd like to sort the data in a second table I created based off the data in the first table. I've attached a screenshot to help clarify my question.
I would like the data in "Table 2" to be sorted by the data in Column F of "Table 1" in descending order. So I'd Like Amex & Credit One to appear on the first two lines, followed by First Premier, Etc. I'd also like all the data in Rows C, D & E to be included.
I know there is probably a very simple solution to this - but I'm an excel novice so tak