In the attached, ( ExpertsExchangeExample2.xlsm.xlsx
) I have several groups of data. This is produced automatically from 3rd party software.
I would like a way, if possibly, to filter through this by ROW, rather than Column.
For example, in each group we have a Row labelled Responsibility Key. I want to Filter by Responsibility Key.
So in the attached, if I wanted to filter by Responsibility Key 'Collections', then only those with that Key will appear.
The real dataset is 4500 rows long, this is a small example.
Another idea was getting this data into a database such as Access and sorting like that.
Thanks for any advice,