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.
- Follow via:
- RSS
- Email Alert
Question
-1
Votes
Answers (1)
1
Vote
Utility
Check out ASAP utility which gives default provision for highlighting duplicate/identical records.
http://www.asap-utilities.com/
http://www.asap-utilities.com/
14th Apr 2011
Replies
Many thanks, this could be the answer to several problems I have with Excel. Thnaks a lot
Peter
Peter
peterwillmo
14th Apr 2011

































