I have a spreadsheet containing data on radio signals. There are 13 columns and over 1500 rows and each row contains a unique set of data. I need a macro which would be accesible from a rt mouse click. The macro should enable me to select a cell in any column (say d1234) and with a rt mouse click, display all rows of data which include identical data to that in d1234. So, for example if a cell in Column C contained “Radio Monaco” I need to see all rows of data where Column C contained “Radio Monaco”
A further click of the mouse would cancel the filter. Hope this is enough to explain what I need.
