peterwillmo
New Member
- Joined
- May 23, 2010
- Messages
- 27
I have a spreadsheet containing data on short wave radio signals. There are 19 columns and over 3300 rows and each row contains a unique set of data. I have a macro (initially designed by Mr. Excel) which is accessible from the Auto Filter button. The macro enables me to select a cell in any column (say d1234) and with a click on the button, display all rows of data which include identical data to that in d1234. So, for example if a cell in Column C contains "Radio Monaco" I need to see all rows of data where Column C contained "Radio Monaco"<o></o>
A separate click on the Clear Filter button click cancels the filter. <o></o>
Originally I was unable to insert the macro and after several exchanges with your expert I sent a copy of the spreadsheet to you and your expert inserted the appropriate macro and returned the spreadsheet which has worked perfectly ever since.<o></o>
<o></o>
However I have since expanded the spreadsheet to contain sets of data on several additional sheets and have tried but failed miserably to insert the same macros in each of the new sheets.<o></o>
<o></o>
<o></o>
I believe the macros are:<o></o>
Module11.CustonFilter<o></o>
Module12.CustonFilter<o></o>
<o></o>
I assume that the macros are linked to the original spreadsheet but will not operate on additional sheets added to the original version.<o></o>
<o></o>
Can you please advise how I can get this macro to operate in spreadsheets other than the original?<o></o>
<o></o>
Your help would be very much appreciated. I am using an XP computer with MS Office 2003
Regards,
Peter
A separate click on the Clear Filter button click cancels the filter. <o></o>
Originally I was unable to insert the macro and after several exchanges with your expert I sent a copy of the spreadsheet to you and your expert inserted the appropriate macro and returned the spreadsheet which has worked perfectly ever since.<o></o>
<o></o>
However I have since expanded the spreadsheet to contain sets of data on several additional sheets and have tried but failed miserably to insert the same macros in each of the new sheets.<o></o>
<o></o>
<o></o>
I believe the macros are:<o></o>
Module11.CustonFilter<o></o>
Module12.CustonFilter<o></o>
<o></o>
I assume that the macros are linked to the original spreadsheet but will not operate on additional sheets added to the original version.<o></o>
<o></o>
Can you please advise how I can get this macro to operate in spreadsheets other than the original?<o></o>
<o></o>
Your help would be very much appreciated. I am using an XP computer with MS Office 2003
Regards,
Peter