Question Locked

Excel 2003 Special Filter

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by peterwillmo

Many thanks, this could be the answer to several problems I have with Excel. Thnaks a lot
Peter

This discussion is closed to new replies.