I have posted several other problems on here, but feel I'm being too complicated in my ask so I am breaking this down to a single step at a time.
I have an Excel workbook with 2 sheets, one named Report and one named Summary. I have a list of cycle names on the Summary tab in cells A2:A50. What I would like to do is run a macro that searches column A on my Report tab for the cycle name found on my Summary tab in cell A2. When the text that's located on the Summary tab in cell A2 is found on the Report tab, I want the entire row highlighted. I want the macro to continue searching all rows until the last row has been searched for the matching text from Summary tab cell A2 and the last row has been highlighted when it's found on Report Sheet in column A.
Then I would like to be able to continue running additional macros for the cycle name on the Summary tab in cell A3 highlighting all the matching rows on the Report tab a different color than the rows highlighted from the first macro, once that macro is done running, I want to be able to run a macro for the cycle name on the Summary tab in cell A4 and so on and so forth until I've been able to search and highlight all rows on the Report tab that match the text found in all my cycle name fields from the Summary tab.
I want each macro to be able to be run independently of each other. Right now I would like to set it so that I can just hit Run on the Macro tab and run each one individually.
Can this be done?
I have an Excel workbook with 2 sheets, one named Report and one named Summary. I have a list of cycle names on the Summary tab in cells A2:A50. What I would like to do is run a macro that searches column A on my Report tab for the cycle name found on my Summary tab in cell A2. When the text that's located on the Summary tab in cell A2 is found on the Report tab, I want the entire row highlighted. I want the macro to continue searching all rows until the last row has been searched for the matching text from Summary tab cell A2 and the last row has been highlighted when it's found on Report Sheet in column A.
Then I would like to be able to continue running additional macros for the cycle name on the Summary tab in cell A3 highlighting all the matching rows on the Report tab a different color than the rows highlighted from the first macro, once that macro is done running, I want to be able to run a macro for the cycle name on the Summary tab in cell A4 and so on and so forth until I've been able to search and highlight all rows on the Report tab that match the text found in all my cycle name fields from the Summary tab.
I want each macro to be able to be run independently of each other. Right now I would like to set it so that I can just hit Run on the Macro tab and run each one individually.
Can this be done?