I have a table (A6:AA2026) where column contains 14 different names. I want to hide column A but have it sort based on the contents of cell K1 (a data validation cell containing a list of the the 14 names in column A). How can I do this?
April 5, 2013 6:52 PM
April 5, 2013 7:02 PM