On the SEPY tab is a sample data file. The Service IDs in columns D, V, AM and BD are the same. The Service IDs will be in different cells within each column. The Service IDs will not be lined up consecutively like I have them. The source file has 2252 rows of data. I cannot provide the exact source file.
I have created a sample file showing what columns the Service IDs will be in W, G, AO and BF. The Service IDs has a rule ZNF assigned. I need a solution that will find all of these Serivce IDs and change the rules to Z01.
I should be able to recreate this solution on my work computer as I will not be able to move the data file from my work computer. I must be able to recreate the solution (macro or script) on my work computer to test the solution. This means that I will need instrctions on how to replicate the soluiton.