This is a snip of my macro I'm using for another part of the document at work, it works great there but I need it to do more, maybe someone can revise it? Or it might require a new one:
Application.ScreenUpdating = False
Set rg = Intersect(Range("C:C"), ActiveSheet.UsedRange)
For Each c In rg.Cells 'Only search column C
Select Case c.Value
Case "CT" 'Old value
c.Value = "Y" 'New value
Basically if anything says CT it needs to be REPLACED to "Y" (for yes)
The problem with this script is I need it to do one more thing.
If the data in that cell does not say "CT" and says "MRI" for example I need "MRI" replaced to "N" (for No)
Sorry I'm a noob at this!