Hello Friends. I'm looking for a way/code to automatically select the cells in Column 2 that have the same page number associated with them in Column 1. Then I want to call a macro and then repeat the process. I have provided the link for the 15kb macro enabled excel file with which I need help. The macro is in the file. Many thanks for your time. https://www.filesanywhere.com/fs/v.aspx?v=8b6c648a5d6373af9da6