I am building a spreadsheet to analyze different locations of our business
(25 total). I want to have my headings in column A instead of across the top
of the page. When I get done typing in all the information for each
location, I would like to make it so I select 1, or compare different
locations side by side by selecting them in a drop down box. Basically I
would like to autofilter but by the column instead of the top row. I seen it
this way at my previous job, but do not know if it was autofilter or another
application.