Hello,

I'd like some help writing a macro/ script. I want to search for a value ("XYZ-123", case sensitive), then paste another value ("a12345", also case sensitive) in the cell 15 columns to the right of the first value. Then continue that for the entire sheet (a "replace all" sort of function).

Thoughts?

IR