Excel 2003 Special Filter

By peterwillmo ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums